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
