No, because that'll leave duplicate people. Not that this database is that big, but sooner or later, I'm bound to wonder why I've got 2 of some of these dudes...since it's a collateral line and all, we know I will (g). Cheryl Bill Linn wrote: > 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. >> -- There should be no attachments on this message, unless I specifically mentioned them above.