Search by multiple fields

[jnaoum]

Hi I just wanted to find out how to do a search in a membership database that is set up on FileMaker Pro 6 (on Windows XP). It's a membership database at present with 5000 records and our previous FileMaker person (who no longer works for the organisation) set up a script to search for and export records from Queensland. I'd like to duplicate the script and change it so it searches for the same other fields, but change the value it searches for in the 'State' field to a different state.

The script is:

Perform Find [Restore, Replace Found Set]

Sort [Restore, No dialog]

If ['Status(CurrentFoundCount)>0"]

Export Records [Restore]

End If

So this script appears not to specify any search terms to change, and I don't know where to look for the terms. I tried just duplicating it, but it doesn't appear this is changeable. Does anyone know where I'd look to find out this information, I presume it's a script or something, but it doesn't appear to call any script...

Cheers!

[Fitch]

FileMaker 6 doesn't let you specify searches in a script that way. (Newer versions do.) You have to first perform the search, then go into your script and edit it, and then when you close the script it will ask if you want to replace your find request. Say OK and there you have it.