Combining duplicate marriages

Replies to This Discussion

Permalink Reply by Bob Rowe on November 19, 2015 at 4:59pm

Each marriage should have its own MRIN. I must be missing something because I don't see what is duplicated. Might also be helpful to know exactly what set of instructions you are using so that we can maybe help you understand them.

Permalink Reply by Ron Taylor on November 20, 2015 at 8:48am

First, a couple could have multiple marriages in the case where they married, divorced, then re-married, etc.

To delete a marriage in Legacy, right click on the marriage in Family tab, then click "Remove Marriage Link".

This script (part of LTools) can help find possible duplicate marriages in the database.

SELECT tblMR.IDMR, tblMR.IDIRHusb, tblMR.IDIRWife FROM tblMR, tblMR AS tblMR_1 WHERE ((tblMR.IDMR<>tblMR_1.IDMR) AND (tblMR.IDIRHusb=tblMR_1.IDIRHusb) AND (tblMR.IDIRHusb<>0) AND (tblMR.IDIRWife=tblMR_1.IDIRWife) AND (tblMR.IDIRWife<>0)) ORDER BY tblMR.IDIRHusb

Permalink Reply by John Archer on November 20, 2015 at 2:16pm

Thanks Bob. I am away from home at present and I will get back to you shortly and respond properly.

Permalink Reply by John Archer on November 21, 2015 at 8:03pm

Back home again Bob.

I have a family file of about 3600 names I am working on at present. It was sent to me as a gedcom about 10 years ago. One of two brothers had some of the children attributed to him which belonged to the other. In attempting to change the children over I ended up with having to add the parents again and that is where I ran into trouble. The father added ok but when I tried to add the mother the only way I could find to do it was to accept another marriage and of course I now have 3 duplicates. I found the answer in the help index but for the life of me could get to the 'combine' option. Could you please advise me how to correct it?

I have also another problem with this family file inasmuch it added a "record change" event to all the people dated in 2005. It now shows up as "event after death". It is a huge job to delete all these because it can't be done without a confirm warning which means two clicks for each one. Any suggestions?