Find matches to a list of Zip Codes

[wplate]

I would like to find entries in our database based on their region, found by zip code. I have a list of zip codes that I would like to search for, how can I have FileMaker show me all the records that are in my list?

I don't want to have to create a new find request for every zip code, that would take me forever to do. I figure FMP has some way to do this for me. :-)

[mr_vodka]

Loop through your list and create a new request each time. When it exits the loop perform the find.

[wplate]

Thank you, as usual I didn't even think of scripting it.

Here's the script I came up with based on your suggestion, however FMP always finishes the script telling me that no items met the search criteria. I've never scripted a Find before, am I doing it right?

[-Queue-]

It would probably be faster to use a relationship from a global text field to the zipcode field. You can enter the zipcodes into the global field in Browse Mode, separated by carriage returns, and use a script with

Commit Records/Requests

If [isEmpty(globalToZipcodeRelationship::serial)]

Show Custom Dialog ["None of the requested zipcodes could be found."]

Else

Go to Related Record [show only related; "globalToZipcodeRelationship"]

End If

[wplate]

Perfect! Thank you, this is indeed the kind of thing I was looking for. Works great.