Run find based on a field in a script

[Ziv Jacoby]

Hi all,

Can I preform a find request where the criteria is another field.

The example I'm trying to run is:

I have a date field and two global dates fields. I want to run a script to only find the records were the date field is in the range of the to global fields.

Thanks,

Ziv

[comment]

Yes, of course you can. The key is to enter Find mode with no stored requests specified, and to set field/s to the desired criteria. See an example here:

http://www.fmforums.com/forum/showpost.php?post/288275/