Legacy Family Tree fans

756 members

Description

A group of Legacy Family Tree users or those interested in learning more about Legacy.
Comments Discussions Members

Combining duplicate marriages

by John Archer

Nov 19, 2015

I have 3 married couples that have separate MRINs. I have not been able to understand the instructions in 'help' to fix it. Could someone please explain?

  • up

    Bob Rowe

    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.

    Nov 19, 2015

    • up

      Ron Taylor

      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

      2

      Nov 20, 2015