Return to FileMaker.com
Can this be done?
I need to run a monthly report and the status of individuals can be either active, pending, drop or sample.
Can I run a find using multiple search criteria, active and pending, or do an omit - drop and sample. I want both the active and pending individuals in the report.
It seems when I do the first find/omit and try to do a find or omit on the subset of records, the find operation seems to be applied on the entire database and not the the subset.
Can this be done? How?
Thanks in advance.
To apply a find to just the records in your found set, use Constrain Found Set. This can be in a script and you'll also find it as a menu option when performing manual searches.
Retrieving data ...