AnsweredAssumed Answered

Matching/Scrubbing A Field In Two Databases

Question asked by bodhibrian on Nov 29, 2009
Latest reply on Dec 21, 2009 by bodhibrian


Matching/Scrubbing A Field In Two Databases


Hi There.

Thanks in advance for your time, energy, and help.


FMP 10

Mac OSX 10.6.2

Beginner to Databasing/FMP/Script Syntax


I have one database of contact records that has name, address, phone number, email, etc.

I have a 2nd database with a single field or simply a list of emails that is separate from the 1st database.


I want to compare my 2nd list of emails to the 1st (Primary) database and create a 3rd database with all of the remaining information for each match appended and included in the 3rd database. 


For example, if the email from the 2nd list matches one in the 1st database then copy that whole record over to a 3rd database.

And I would want it to do this for every match.


The end goal would be to have a 3rd list/database with full records for each matched email.