Jump to content

Multiple find on same field


This topic is 7784 days old. Please don't post here. Open a new topic instead.

Recommended Posts

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) crazy.gif" border="0

Link to comment
Share on other sites

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

Link to comment
Share on other sites

This topic is 7784 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share

×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.