AnsweredAssumed Answered

finding records that match another table

Question asked by chadmccomas on Jul 1, 2013
Latest reply on Jul 1, 2013 by philmodjunk

Title

finding records that match another table

Post

     I have a question.  In Filemaker, I have two tables:

      

     1.  customers

     name, address, city, state, zip, phone

      

     2. zipcodes

     zip

      

     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.  : )

Outcomes