Jump to content

Merging duplicates with child records

Recommended Posts

Posted (edited)

I'm trying to figure out the best way to structure my data, so that I could "merge" duplicate parent records and combine all of the child records.


For example:

"ABC Enterprises" has a number of child records and linked records (contact names, work orders, asset records, etc.) - meanwhile there are second and third records "ABC Enterprises Ltd." and "ABC Enterprise" that has similar child and linked records. 

I've attached a file with some sample records. This example is overly simple to illustrate what I'm trying to do. In real-world, each company would have many other pieces of information (address & contact info, warranty documents, etc.) across a number of different tables. I'm guessing the process would look something like delegating a "master" company record.

If it's feasible, I would like to use the same process to combine other records, such as duplicate phone numbers, contacts, etc. 

I found a few articles online, this process is used sometimes for medical records and is apparently referred to as a "Master Patient Record" or "Master Name Index" from what I can see. 

What is the best way to accomplish this?

Thank you!

ABC sample.fmp12

Edited by Matt Cudmore
Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

  • Create New...

Important Information

By using this site, you agree to our Terms of Use.