Crazy Find within Find Help

[falkaholic]

Hi, I've got a killer find problem.

I've got a unique set up here. The user needs to do a custom find and then run a report in that find. Easy enough.

Not when the report needs to do another find on 4 fields. These fields contain MMYY combos and the report finds a range (entered in globals). The script that runs the report Enters Find Mode, then does 4 new requests (since the report does ANY within the range) and then does a Perform Find.

I need to combine with the user find since the user needs to filter out some of them.

I've tried everything using Modifly Last Find etc. but that just adds records to the found set. I can't use a field to mark the found records because I have about 2000 records and setting them on and off all the time to stupid.

Any help?

(using 5.5)

[falkaholic]

solved my own problem.

make a calculation that used a case() to see if any of the 4 fields were in the range (1 for yes, 0 for no), then did a modify find then a search for 1.

Hope this helps someone.