finding records that match another table
I have a question. In Filemaker, I have two tables:
name, address, city, state, zip, phone
Is there a way to search through the customers table and only show results where the zip exists in the zipcodes table?
In other words, I have like 20,000 customers over the years. I created the zipcodes tables with specific zipcodes so I can find only customers that have those zip codes. It is 400+ zips though. So I don't want to click on New Request 400+ times.
Does this make any sense? Thanks for your help. : )