Return to FileMaker.com
searching fields for OR
I am trying to find records where a certain field has either a "00" value or empty.
I know that using the "=" operator in find mode allows for searching for blanks. but how can i "or" it with the other value? Is it possible to do this in one line without extending the found set?
to do such FIND you'll need two request. Something like:
Enter Find Mode [ ]
Set Field [ yourField ; "=" ]
Set Field [ yourField ; "=00" ]
Perform Find [ ]
Retrieving data ...