I've encountered this in the past with my data. Assuming that for the two marriages, both husbands had the same RIN and both wives had the same RIN, I reviewed both marriages to make sure that all the children in both listed marriages have been identified into the one marriage (in some cases I had to add the child manually) that I wanted to retain. I also validated the date, place information for the marriage was correct as well on the marriage I wanted to retain. Once the children and the marriage information was correct, I then simply deleted the marriage I wanted to get rid of. This resulted in not merging the two marriages, but ultimately resulted in just the one marriage for the husband and wife that I wanted in the first place. The down side is that I now had a gap in the MRIN numbers when looking at the marriage list but at least the marriage was no longer there, but that happens all the time when merging individual records that then automatically merge marriages as Gaylon indicated in his message. Hope this helps. THANKS, Val Olds -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of [email protected] Sent: Friday, December 07, 2007 12:01 AM To: [email protected] Subject: PAF-5-USERS Digest, Vol 2, Issue 288 Today's Topics: 1. Can I merge marriages? (singhals) 2. Re: Can I merge marriages? (Stewart Millar) 3. Re: Can I merge marriages? (singhals) 4. Re: Can I merge marriages? (Gaylon Findlay) 5. Re: Can I merge marriages? (Bill Linn) ---------------------------------------------------------------------- Message: 1 Date: Thu, 06 Dec 2007 21:10:32 -0500 From: singhals <[email protected]> Subject: [PAF-5] Can I merge marriages? To: [email protected] Message-ID: <[email protected]> Content-Type: text/plain; charset=us-ascii; format=flowed I know exactly what I did, why, and how. My bad, no question about it. I even know the hard way to fix it. Question *IS*, is there an easy way? What I did resulted in numerous people being married twice to the same person. Is there a way to merge the marriage records? (If I just unlink one of 'em, they're still in the db floating around in the alpha reports. Merging the spouses seems to result in duplicate children which then also need merging creating duplicate grandchildren etc etc.) If PAF won't merge marriages, will Legacy? Cheryl -- There should be no attachments on this message, unless I specifically mentioned them above. ------------------------------ Message: 2 Date: Fri, 7 Dec 2007 03:02:06 -0000 From: "Stewart Millar" <[email protected]> Subject: Re: [PAF-5] Can I merge marriages? To: <[email protected]> Message-ID: <[email protected]> Content-Type: text/plain; charset="us-ascii" Despite a seeming lifetime of use of PAF - merging in basic PAF fills me with dread and I have rarely got it right - and never really know why I got it right or more often when - and I have - had similar results to you with merged marriages. I now do any PAF merging in PAFInsight - which gets it right every time. Remember - essentially you are merging individuals (not marriages) - if the merged individuals have been married to different people - you will get correctly, multiple marriages - however, if the merged individuals have from their respective different databases been married to the same individual - the result will be multiple marriages to the same individual & corresponding multiple children. In such cases care must be taken to ensure that the two merged records are not married to the same spouse. The above paragraph may take some unravelling - but use PAFInsight - it's easier. Regards, Stewart -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of singhals Sent: 07 December 2007 02:11 To: [email protected] Subject: [PAF-5] Can I merge marriages? I know exactly what I did, why, and how. My bad, no question about it. I even know the hard way to fix it. Question *IS*, is there an easy way? What I did resulted in numerous people being married twice to the same person. Is there a way to merge the marriage records? (If I just unlink one of 'em, they're still in the db floating around in the alpha reports. Merging the spouses seems to result in duplicate children which then also need merging creating duplicate grandchildren etc etc.) If PAF won't merge marriages, will Legacy? Cheryl -- There should be no attachments on this message, unless I specifically mentioned them above. ------------------------------- To unsubscribe from the list, please send an email to [email protected] with the word 'unsubscribe' without the quotes in the subject and the body of the message ------------------------------ Message: 3 Date: Thu, 06 Dec 2007 22:19:52 -0500 From: singhals <[email protected]> Subject: Re: [PAF-5] Can I merge marriages? To: [email protected] Message-ID: <[email protected]> Content-Type: text/plain; charset=us-ascii; format=flowed Uhhh ... I'm not sure I understand what you think I said? (g) I'll try PAFI ... not much to lose, I guess. Thanks, Stewart. Cheryl Stewart Millar wrote: > Despite a seeming lifetime of use of PAF - merging in basic PAF fills me > with dread and I have rarely got it right - and never really know why I got > it right or more often when - and I have - had similar results to you with > merged marriages. > > I now do any PAF merging in PAFInsight - which gets it right every time. > > Remember - essentially you are merging individuals (not marriages) - if the > merged individuals have been married to different people - you will get > correctly, multiple marriages - however, if the merged individuals have from > their respective different databases been married to the same individual - > the result will be multiple marriages to the same individual & corresponding > multiple children. In such cases care must be taken to ensure that the two > merged records are not married to the same spouse. > > The above paragraph may take some unravelling - but use PAFInsight - it's > easier. > > Regards, > Stewart > > > -----Original Message----- > From: [email protected] > [mailto:[email protected]] On Behalf Of singhals > Sent: 07 December 2007 02:11 > To: [email protected] > Subject: [PAF-5] Can I merge marriages? > > I know exactly what I did, why, and how. My bad, no > question about it. I even know the hard way to fix it. > > Question *IS*, is there an easy way? What I did resulted in > numerous people being married twice to the same person. Is > there a way to merge the marriage records? > > (If I just unlink one of 'em, they're still in the db > floating around in the alpha reports. Merging the spouses > seems to result in duplicate children which then also need > merging creating duplicate grandchildren etc etc.) > > If PAF won't merge marriages, will Legacy? > > Cheryl > -- There should be no attachments on this message, unless I specifically mentioned them above. ------------------------------ Message: 4 Date: Thu, 06 Dec 2007 20:30:29 -0700 From: Gaylon Findlay <[email protected]> Subject: Re: [PAF-5] Can I merge marriages? To: [email protected], [email protected] Message-ID: <[email protected]> Content-Type: text/plain; charset=us-ascii; format=flowed Cheryl: Let's say that you have "Bob Jones" married to "Sally Rogers". And you have two copies each of Bob and Sally. Bob (RIN 1) is married to Sally (RIN 2), and the marriage is MRIN 3. The second Bob (RIN 4) is married to the second Sally (RIN 5) in marriage MRIN 6. Once you merge the two copies of Bob (RINs 1 and 4), you will still have two marriages (MRINs 3 and 6). There will only be one copy of Bob, and that is RIN 1. So now you have: Bob (RIN 1) is married to Sally (RIN 2), and the marriage is MRIN 3. Bob (RIN 1 -- remember, he's been merged, and there is no longer a RIN 4) is married to the second Sally (RIN 5) in marriage MRIN 6. Now, when you merge the two copies of Sally (RINs 2 and 5), you will end up with only one copy of Sally, and that will be RIN 2. At this point in the merge process, PAF should be smart enough to recognize that since MRIN 3 and MRIN 6 both have the same two partners, it will automatically merge the two marriages. So you will end up only with marriage MRIN 3. MRIN 6 will be gone. In summary, any time you have two copies of the same marriage, once you merge the two partners, the extra marriage will be merged. Concentrate on merging the individuals, and the marriages should take care of themselves. Gaylon PS. If the original RIN 1=RIN 2 couple had children, and the original RIN 4=RIN 5 couple had a duplicate set of children, then you will eventually have to merge the children. singhals wrote: > I know exactly what I did, why, and how. My bad, no > question about it. I even know the hard way to fix it. > > Question *IS*, is there an easy way? What I did resulted in > numerous people being married twice to the same person. Is > there a way to merge the marriage records? > > (If I just unlink one of 'em, they're still in the db > floating around in the alpha reports. Merging the spouses > seems to result in duplicate children which then also need > merging creating duplicate grandchildren etc etc.) > > If PAF won't merge marriages, will Legacy? > > Cheryl > > ------------------------------ Message: 5 Date: Thu, 6 Dec 2007 23:49:09 -0500 From: "Bill Linn" <[email protected]> Subject: Re: [PAF-5] Can I merge marriages? To: <[email protected]> Message-ID: <[email protected]> Content-Type: text/plain; format=flowed; charset="iso-8859-1"; reply-type=original Pardon my stupidity please but? Couldn't we just delete one marriage? ----- Original Message ----- From: "Gaylon Findlay" <[email protected]> To: <[email protected]>; <[email protected]> Sent: Thursday, December 06, 2007 10:30 PM Subject: Re: [PAF-5] Can I merge marriages? > Cheryl: > > Let's say that you have "Bob Jones" married to "Sally Rogers". And you > have two copies each of Bob and Sally. > > Bob (RIN 1) is married to Sally (RIN 2), and the marriage is MRIN 3. > The second Bob (RIN 4) is married to the second Sally (RIN 5) in > marriage MRIN 6. > > Once you merge the two copies of Bob (RINs 1 and 4), you will still have > two marriages (MRINs 3 and 6). There will only be one copy of Bob, and > that is RIN 1. So now you have: > > Bob (RIN 1) is married to Sally (RIN 2), and the marriage is MRIN 3. > Bob (RIN 1 -- remember, he's been merged, and there is no longer a RIN > 4) is married to the second Sally (RIN 5) in marriage MRIN 6. > > Now, when you merge the two copies of Sally (RINs 2 and 5), you will end > up with only one copy of Sally, and that will be RIN 2. At this point in > the merge process, PAF should be smart enough to recognize that since > MRIN 3 and MRIN 6 both have the same two partners, it will automatically > merge the two marriages. So you will end up only with marriage MRIN 3. > MRIN 6 will be gone. > > In summary, any time you have two copies of the same marriage, once you > merge the two partners, the extra marriage will be merged. Concentrate > on merging the individuals, and the marriages should take care of > themselves. > ------------------------------ To contact the PAF-5-USERS list administrator, send an email to [email protected] To post a message to the PAF-5-USERS mailing list, send an email to [email protected] __________________________________________________________ To unsubscribe from the list, please send an email to [email protected] with the word "unsubscribe" without the quotes in the subject and the body of the email with no additional text. End of PAF-5-USERS Digest, Vol 2, Issue 288 *******************************************