Enter find mode and specify Porsche, and Tennis in the respective related tables.
Perform the find
Return to find mode and specify Ford and Baseball.
constrain the found set.
This can be done manually or via a script.
I am using portals to display the information from the related tables. When I enter find mode it only lets me put in a single item in each portal. Any way to get it to accept more than one value at a time (which works in edit mode).
Thanks for your help.
I know, that's why my example has you specify just one criterion in each portal, perform the find, specify additional criteria in the portals, constrain found set...
At no time in that process do you enter more than one criterion in a given portal.
The problem is that users will almost always be entering multple criteria...in some cases 5-10 for each value.