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?