I am trying to figure out how to use FMP's Boolean capabilities.
For example, I would like to search all my records for any containing X or Y in field 1, and not Z in filed 2.
Thanks for any tips!
By hand or in a script?
The basic steps are the same, but implementation details look a bit different.
In find mode, the actions that create/delete a record create/delete a request instead.
Enter find mode
Enter X in field 1
Create a new request
Enter Y in field 1
Enter Z in field 2
Select the omit option for this request. (button in status area)
Thank you so much! That was easy and exactly what I need.
Retrieving data ...