AnsweredAssumed Answered

Can a layout contain other layouts, just like Access forms contain subforms?

Question asked by wladdy on Oct 19, 2010
Latest reply on Oct 19, 2010 by philmodjunk

Title

Can a layout contain other layouts, just like Access forms contain subforms?

Post

I am migrating from Access to Filemaker and I have the following question.


Can a layout contain other layouts, just like Access forms contain subforms?

I have a database with three tables: 'Days', 'Shows' to record performances given on various days and 'Acts' to record the various acts making up each performance. There is a one-to-many relationship from Days to Shows and another one-to-many relationship between Shows and Acts.


I want to browse through all the levels of the hierarchy within a single layout.

In Access, I have a form for Days containing a subform for Shows. In turn, the subform for Shows contains a subform for Acts. Each of the three forms has its own navigation buttons and record addition button. When I move from one Day to another, the subform Shows displays the first show for that day and the sub-subform Acts displays the first act of that show. If I move to another Show within the Same Day, the sub-subform Acts display the first act of that other show (when I say 'first', I refer to pre-specified sorting criteria within each table).

This system does not only filter when I browse, but also when I create records. Indeed, if I add a new record in Act or in Show, its foreign key field content will be automatically by populated to match the primary key field content of its parent.

I assume that I could get similar results in FileMaker Pro 11, but it appears to me that FM portals cannot have subportals. Furthermore, portals seem to be restricted to list mode (as opposed to form mode). Finally, it seems impossible to create a a new record from within a portal.

Is there another tool that I should use? Is my three-level-form approach inherited from Access preventing from seeing layout paradigms specific to Filemaker?


Any help or direction would be much appreciated.

Outcomes