In Find mode is there an "OR" operator?
I want to perform a Find for records created by John OR Scott (but I don't want to have to click "New Request")
jlwayne wrote: In order to search for John or Scott I have to enter all of the other info in the other fields in the New Request.
In order to search for John or Scott I have to enter all of the other info in the other fields in the New Request.
Not really - you could duplicate the first request and change the name only. Anyway, as I said, you can have a script handle this for you.
Creating a new request is the way to make an OR find. If you prefer, the process can be scripted.
Okay, thank you.
This is inconvenient. I am performing a Find for Records of a particular "Project Number" Between certain "Dates" and created by "John OR Scott"
In order to search for John or Scott I have to enter all of the other info in the other fields in the New Request. It would be better if I only had to enter "Date", & "Project Number" ONCE (in the first row of the find).
I see - I'm rather new to creating databases and FMP. Can you show me an example of what the script might look like?
Enter Find Mode [Pause]
If [ PatternCount ( Name ; " OR " ) ]
Set Variable [ $names ; Substitute ( Name ; " OR " ; ¶ ) ]
Set Field [ Name ; GetValue ( $names ; Get ( RecordNumber ) ) ]
Exit Loop If [ Get ( RequestCount ) ≥ ValueCount ( $names ) ]
Duplicate Request 
Perform Find 
That or use Constrain. Find by date the constrain from there.
-- sent from my iPhone4 --
Finding data is one of FileMakers biggest strengths, you just have to know how to use it and how it works.
As has been said OR is obtained by making another concurrent find request, it's strength lies in the fact that there are NO PRACTICAL LIMITS to the number of find requests and their complexity.
In the case of ONE 'OR' Enter find, enter the data for the find (the criteria) then hit Control + D or on a MAC Command + D and simply change the data that matches the 'OR' part of the find then hit enter.
Retrieving data ...