There are two ways to install multiple search criteria for a single field in a script:
1. Perform Find with restored find requests
2. Construct Find requests in the script with new requests and set field
The first one is less script lines but the second is favoured by some developers for the explicit nature of the scripting lines.
To do the first one:
1. Add the script step Perform Find to your script in the desired position
2. Click the Specify Find Requests option
3. Click the New button to add a new request
4. In the next dialog, select the City field and in the Criteria box, type Denver
5. Click Add and then click OK
6. Repeat steps 3 - 5 for the other two cities.
7. You have now created multiple stored requests in the script.
To do the second one:
1. Add the script step Enter Find Mode and uncheck the Pause option
2. Add the script step Set Field, specify the target field as City and the calculated result as "Denver"
3. Add the script step New Record/Request
4. Repeat step 2 for the second city
5. Add the script step New Record/Request
6. Repeat step 2 for the third city
7. Add the script step Perform Find and do not specify find requests
8. This script sequence will enter find mode, create multiple requests and perform the find.
Try them both and use whichever one makes most sense to you.
When in Find mode looking at a form, is there any way to go to a field and enter multiple criteria right in the field? ("Denver" or "Phoenix") ... Or do you really have to create multiple requests?
There is no way to do this with a standard Find request in FileMaker Pro.
It can be done as part of a scripted process but that involves the script adjusting the user input to the standard multiple requests before performing the find.
So do you want to simply store a multiple request find in a script or do you want to present and 'easier' interface to the user for constructing finds?