FileMaker Found Set Of Child Records Showing Up In Portal

From Dwayne Wright PMP, PMI-ACP, CSM
Certified FileMaker Developer

WEB: www.dwaynewright.com
EMAIL: info@dwaynewright.com
TWITTER: dwaynewright
YOUTUBE: FileMakerThoughts

There are a number of ways to have a found set of records show up in a portal. I'm going to go through a few of them and illustrate how they work.

One method (a little long in the tooth) is to perform the find in the child file and then mark the found set of records with a key. This is typically done via the replace command or with a looping script that sets each record after another. Then return to the parent file, set the primary key and the portal displays the information.

Another method involves copying all the key id records in the found set as a return delimited result. Then take that data and put it into a parent match field. This method has been simplified with the List function that was introduced with FileMaker 8.5.

Then there has been a lot of other techniques that have been introduced and I will need to research those. I haven’t had a need to show a found set in a portal as much because I tend to use multiple windows. Having the ability to see a found set in another window reduces the need to illustrate the found set in a portal.

=
More info about the author and FileMaker in general, contact me at info@dwaynewright.com.

© 2008 - Dwayne Wright - dwaynewright.com

The material on this document is offered AS IS. There is NO REPRESENTATION OR WARRANTY, expressed or implied, nor does any other contributor to this document. WARRANTIES OF MERCHANT ABILITY AND FITNESS FOR A PARTICULAR PURPOSE ARE EXPRESSLY DISCLAIMED. Consequential and incidental damages are expressly excluded. FileMaker Pro is the registered trademark of FileMaker Inc.