Thank you for your post!
You might find the Extend Found Set useful in this scenario.
I'm also going to move this thread from the FileMaker Community Feedback Space (which is specifically for input on the Community itself) to the Discussions Space where you should receive more views and potentially more feedback on this topic!
You can't put calculation expressions into that dialog to use as stored criteria.
clear those requests, add use additional set field steps to specify this criteria just as you did for the first.
But that check box field is going to be a problem. Are you looking for records where both check box values are selected or looking for records where one or the other has been selected?
What makes this tricky if you need records where both are selected is that different records can show the same two check boxes selected, but store the data differently as the value are entered into the field in the order that the user clicked the check boxes.
Thanks everybody! This community always helps me re-think much better approaches. (thanks Menno for the sample db)
Phil, the way I have it set up is actually a radio button set of 10 values.
In other words, I would like the script to... Find me all jobs over 90 days old that have the radio button selection "out for approval" or "waiting for FTO". It would never be both.
It would never be both.
unless the user holds down the shift key and clicks both. Users do the darndest things sometimes.