AnsweredAssumed Answered

Merge changed records in two databases

Question asked by DrBev on Feb 12, 2015
Latest reply on Feb 12, 2015 by philmodjunk


Merge changed records in two databases


I have inherited a database which has a master record of our membership. I often update this membership database. I use FMPro v12.

To help me with my workload, I will be using a part-time worker. Instead of having her work directly in the main database (because I don't want her to accidentally delete records, and I also want to be using the database while she is using it), I am thinking of creating a copy of this database which she will then use to update records and make changes.

When ready, I would like to merge any changed fields from her database to mine, while keeping any of the changes I have made, even if they are for the same record. 

Is there a way to do this? What are best practices for achieving this?