Did you guys report this as a bug? Just double-checking. It was a bug even for GEDCOM import a long time ago (when I started using Legacy... v5?). Would've thought it would have been fixed 'everywhere' - tho maybe nFS interface wasn't in place at that time. --Paula in Texas Researching: Adair Baker Beasley Benson Betz Bigley Blagrave Burton Chapman Clement Clough Coppernoll Costine Daulton Dinwiddie Doody Ellis Exline Field Floran Floyd Gates Goodale Gordon Gump Hale Harbaugh Hind Hopkins Hughes Hurdle Jones Klein Koyle Laswell McDonald Misner Passwaters Pelton Roberts Roche Ryburn Short Singer Sullivan Weller Williams
________________________________ From: Ron Taylor <[email protected]> To: [email protected] Sent: Sat, January 21, 2012 3:00:55 PM Subject: Re: [LegacyUG] Mass edit to Child-Parent Relationships Scott, I am well aware of the problem of pulling individuals from nFS into Legacy and the child-parent relationships that were being set to "Biological" instead of blank. I had Dennis Kowalek help me with some scripts to fix it which I apply in Ltools. Here are the scripts that I use. UPDATE tblCR INNER JOIN tblCP ON tblCR.IDCPDad = tblCP.IDCP SET tblCR.IDCPDad = 1 WHERE tblCP.CPRelation='Biological' UPDATE tblCR INNER JOIN tblCP ON tblCR.IDCPMom = tblCP.IDCP SET tblCR.IDCPMom = 1 WHERE tblCP.CPRelation='Biological' You could use the same scripts to fix other child parent relatonships as needed. Ron Taylor Legacy User Group guidelines: http://www.LegacyFamilyTree.com/Etiquette.asp Archived messages after Nov. 21 2009: http://www.mail-archive.com/[email protected]/ Archived messages from old mail server - before Nov. 21 2009: http://www.mail-archive.com/[email protected]/ Online technical support: http://www.LegacyFamilyTree.com/Help.asp Follow Legacy on Facebook (http://www.facebook.com/LegacyFamilyTree) and on our blog (http://news.LegacyFamilyTree.com). To unsubscribe: http://www.LegacyFamilyTree.com/LegacyLists.asp
