The new Found Set Portals (Master-Design Layouts) feature in FileMaker 17 allows you to merge form and list view to create incredible new interfaces.
Now, this feature is a doozy and likely to spawn tips and tricks for years to come. The new feature allows a portal to show records from the current found set. That’s right, no self-join relationship necessary! So, how is this useful? Imagine merging a form and list view. There’s no need to click back and forth between a separate form and list view layout. Just click on a portal row and the context of the Body part is changed to the selected row.
SIDE TIP: You don’t need found set portals to merge form and list view. Just create a list view layout and place the form view fields in the header or footer. The only drawback is the form information is always at the top or bottom of the screen. With a portal and FileMaker 17, the location of the form information is back to the body and the portal showing the list can be placed anywhere in the body part, allowing for more interface flexibility.
Found set portals will also enhance pickers or choosers. If you’ve ever created a picker, as a replacement for popup menus, you know what a pain they are to create from scratch. With found set portals, there is no longer a need to create relationships, calculation filters, complicated compound keys or sophisticated scripts to support pickers. Just create a layout with a portal, choose the current table and use a scripted find to change the found set (which will in turn change the content of the portal). Just add a simple button on the portal row to select the ID and you can place the ID from any portal row in any foreign key you want. How easy and cool is that! Say goodbye Selector Connector and say hello to proper use of the Anchor Buoy relational paradigm.