Combining duplicate marriages - Genealogy Wise2024-03-28T19:37:43Zhttp://www.genealogywise.com/forum/topics/combining-duplicate-marriages?groupUrl=legacyfamilytreefans&commentId=3463583%3AComment%3A711231&x=1&feed=yes&xn_auth=noBack home again Bob.
I have a…tag:www.genealogywise.com,2015-11-22:3463583:Comment:7112312015-11-22T02:03:52.952ZJohn Archerhttp://www.genealogywise.com/profile/JohnArcher142
<p>Back home again Bob.</p>
<p>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…</p>
<p>Back home again Bob.</p>
<p>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?</p>
<p></p>
<p>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?</p> Thanks Bob. I am away from ho…tag:www.genealogywise.com,2015-11-20:3463583:Comment:7109572015-11-20T20:16:21.885ZJohn Archerhttp://www.genealogywise.com/profile/JohnArcher142
Thanks Bob. I am away from home at present and I will get back to you shortly and respond properly.
Thanks Bob. I am away from home at present and I will get back to you shortly and respond properly. First, a couple could have mu…tag:www.genealogywise.com,2015-11-20:3463583:Comment:7111452015-11-20T14:48:48.424ZRon Taylorhttp://www.genealogywise.com/profile/RonTaylor
<p>First, a couple could have multiple marriages in the case where they married, divorced, then re-married, etc.</p>
<p></p>
<p>To delete a marriage in Legacy, right click on the marriage in Family tab, then click "Remove Marriage Link".</p>
<p></p>
<p>This script (part of LTools) can help find possible duplicate marriages in the database.</p>
<p></p>
<p>SELECT tblMR.IDMR, tblMR.IDIRHusb, tblMR.IDIRWife FROM tblMR, tblMR AS tblMR_1 WHERE ((tblMR.IDMR<>tblMR_1.IDMR) AND…</p>
<p>First, a couple could have multiple marriages in the case where they married, divorced, then re-married, etc.</p>
<p></p>
<p>To delete a marriage in Legacy, right click on the marriage in Family tab, then click "Remove Marriage Link".</p>
<p></p>
<p>This script (part of LTools) can help find possible duplicate marriages in the database.</p>
<p></p>
<p>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</p> Each marriage should have its…tag:www.genealogywise.com,2015-11-19:3463583:Comment:7112192015-11-19T22:59:44.265ZBob Rowehttp://www.genealogywise.com/profile/BobRowe
<p>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.</p>
<p>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.</p>