Updating a Database

[kipster319]

Does anyone know how to perform an update of records in Filemaker so that it would match records from one database (update database) to another database (master database)?

Example:

Database 'A' has First Name, Last Name, and Email. Database 'B' just has the Email. Can I tell Database 'B' to import or update First Name and Last Name from Database 'A' based on Email?

Thanks in advance,

Kip

[trevorg]

I know in version 5 and up you can do this. When you run the import function (or script it) you need to check the radio button "Update matching records in the current found set" and then check the box that says "Add remaining records" if there might be any new records in database B.

You would set the match field by clicking the arrow in the field map until it changes to a two-way arrow.

The best way is to Show all records prior to doing this. It will automatically find all the matching records (much like a goto relationship). The found set that is left after the import are all the records that were updated/added.

[kipster319]

Thanks for the suggestion! Sounds like what I need!