Search queries on a subset of records
I have a table on which I need to perform periodic (weekly) searches using a series of embedded scripts which returns counts and sums. Instead of having to include the date parameter in every single script. I'm looking for a way to perform these scripts on a subset of records (e.g. the records that are valid for that date). In other words, I need to first tell FMP that the searches need to be performed only a specific set specific records.
Something tells me that there is a way...