Please see the attached sample file where a person (parent) has one-or-more favourite* colours* (child). I want to find the people who like "Cyan" AND "Yellow" which can be accomplished with a Perform Find then a Constrained Find.
However, I have a vague memory this was possible in Find Mode in FileMaker Pro 6 and earlier using multiple portal rows. In Find Mode you could:
(a) enter find criteria into multiple portal rows to construct a narrow "AND" request in the related child table
(b) duplicate the portal row find request if the portal row was active/selected
Does anyone have a copy of FileMaker Pro 6 to test this?
Just curious if my memory is corrupted or we have lost a nifty feature that took me 15 years to discover. In the sample file the Child and Child 2 relationships test if the "allow creation of related records" join option influences the find mode behaviour*.
Thanks in advance.
Michael Richards
Brisbane (Australia)
* no doubt annoying for the USA viewers but this is how we spell "down under" using the Queen's English.
I started with FM 5.0 in 2000 and worked quite much with that version and the following ones (5.5, 6.0).
I don't remember such a feature and am quite sure it did not exist.
Jens