AnsweredAssumed Answered

finding records that match another table

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


finding records that match another table


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


     1.  customers

     name, address, city, state, zip, phone


     2. zipcodes



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