Script to find 12 different zipcodes...simple but eludes me totally..Help?

[AbsoluteVoice4u]

Hello everyone. Using Filemaker Pro 11 and I'm going nuts creating a simple script that looks through all 92,000 records, finds only ones with zipcodes 40502, 40503, 20202 and 21214 and shows them as a found group. My problem is creating the script to accomplish this.... Yes...it's simple but I'm getting nowhere...any help?

[Ocean West]

enter find mode

set field zipcode "=40502"

new record/request

set field zipcode "=40503"

new record/request

set field zipcode "=20202"

new record/request

set field zipcode "=21214"

perform find

this should do it adding = is an exact search

[AbsoluteVoice4u]

Yes, that will do the trick!....Now...should I wish to look up records and use 56 different zipcopdes as a search, is this the same format, or is there a script that I can create (containing all the zipcodes I wish to find, using 21201 or 21202 or 20050 etc? I'm really looking to use a script that I can call upon, as I enter more records. and THANK YOU!

[Ocean West]

the best bet is to create a zip code table a record is a zip code you wish to find.

create record in this table that you want. then

add a relationship between zip code in this table and zip code your data table.

your script step will be go to related records matching on all records in the founds set.

[AbsoluteVoice4u]

I'll take your advice and do just tat...thank you! GREAT FORUM!!!!!!