AnsweredAssumed Answered

Merge changed records in two databases

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

Title

Merge changed records in two databases

Post

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?

 

Outcomes