Does FileMaker have a different method of finding records? I really need to create a find where this "AND" is actually an "OR". It seems it isn't possible on this screen. Can anyone point me in a good direction?
So you're scripting it, and you are probably one script line after enter find mode.
Drop that and, insert a new record / request line and detail your second criteria in another find.
The single requests will represent an OR. Just like in non scripted find mode.
You might find the first part of this discussion helpful:
Scripted Find Examples
There are at least two different approaches to "OR" finds demonstrated. One is what siplus has already described. Another method is to use the Extend Found Set option.
Three alternatives to the standard find do exist:
Using Quick find
Find matching records
Using Go To Related Records
The first two won't really help for "OR", but it is a definite possibility with the third.
Thanks siplus that was a good solution.
Thanks philmodjunk for the help, I'll definitely read through that linked page for more information on finds.
Retrieving data ...