Misc. Info Database
How to do searching in Filemaker Pro (Author: Jen)
If you are doing the search manually(as opposed to in a script), you can:
enter Find mode
enter your criteria into Country
select New Record from under the Records menu
enter your criteria into Favorite Holiday Country
then have it perform the find
This will return only the records that match the values you entered into the
2 separate records.
Or script it using a global field to capture the value you want to search
Enter Find mode [ ]
Set Field ["Country", "gSearch"]
Set Field ["Favorite Holiday Country", "gSearch"]
Perform Find [ ]
I hope this helps.