Multiple find on same field

[Applal]

I am trying to create a script that will do a FIND on a text field that will result in finding two different words, in this case, City names.

I would like to find and show all records with city x AND city y from the same database. I know how to do this with menu commands, but can't seem to find the right combination of script steps to accomplish this. I either get an error, no records found or end up with only the results from the second search city. I have read through the Filemaker Help files and found nothing covering this kind of script. FMP5, if that makes a difference.

(I am VERY new to Filemaker, please forgive if I missed something very basic)

[LiveOak]

Enter Find Mode() <-- make sure restore is not checked!

Set Field(City, "Chicago")

New Record/Request/Page

Set Field (City, "Detroit")

Perform Find() <-- make sure restore is not checked!

If(Status(CurrentError) = 401)

Show Message (No records were found!, OK)

End If

You can use a global field in place of a set city name (you'll need one field per request). -bd

[Applal]

Omigosh! Thank you SO much! I tried it on my file and it works perfectly!