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?

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

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!

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.

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