Performing a find within found set

[ibiubu]

I have a script in my parent file that "Goes to related record" and then runs a script in the related record that "Perform find" with constrain turned on.

Here is my question: I have about 1000 records in the related file. When the script runs, it goes to "Related record" and shows 5 related records. It then runs the "Perform find" script. But even though I have set it to a constrain found set, the script still seems to be doing a find in all 1000 records. I know this because the find it is performing is on a field that can not be indexed, and it takes forever to run the find. If it was only searching within the found related 5 records, it should go pretty fast.

Is there a better way to accomplish this?

Larry

[Lee Smith]

ibiubu,

Update your profile to reflect your platform, operating system and version of FileMaker.

The link i just below your picture, the word "profile" in blue.

Lee

[Balder]

why don't you just loop through those 5 related record...

You could use a layout in your masterfile and place a portal with the relevant data in it.

Just loop through the records in this portal and check the fields...