Here's a couple more SQL that you may find useful. I don't like to have "Biological" as a Relationship-to-Parent-Status so I change them to blank. Both of these scripts should work in Ltools or remove the script title and run them in Access. Tweak them for other combinations. They illustrate how the tables are connected.
"Change Father Relationship to Blank","UPDATE tblCR INNER JOIN tblCP ON tblCR.IDCPDad = tblCP.IDCP SET tblCR.IDCPDad = 1 WHERE tblCP.CPRelation='Biological'" "Change Mother Relationship to Blank","UPDATE tblCR INNER JOIN tblCP ON tblCR.IDCPMom = tblCP.IDCP SET tblCR.IDCPMom = 1 WHERE tblCP.CPRelation='Biological'" Ron Taylor On Sunday, August 3, 2014 8:56 PM, Ken Neundorf <[email protected]> wrote: The highlighted is what I need to do. Thanks for all the help From:Jay 1FamilyTree [mailto:[email protected]] Sent: Sunday, August 3, 2014 10:44 PM To: [email protected] Subject: Re: [LegacyUG] Access Database in Legacy ok, well its a bit confusing here. You first mention that you want to change the Private to Biological or Blank But then you say its the Father Relationship and Mother Relationship that are marked as Private. These are not the same things. When you look at the childrens settings (right click in the area where the children are listed under the parents in a Family View screen) That opens the childrens settings screen Each Child can have a different "Child Status" This field is what you could change to Blank or Biological if they are all set to Private. You dont need access to do that First as always make a backup (and even better make a copy to test on first) Go to VIEW>Master Lists> Child Status. Than COMBINE your Private with a one of the other available (or blank) This will GLOBALLY change all persons. If when looking at the childrens settings the boxes next to Relationship to Father or Relationship to mother are checked (flagged) as Private, then you would need to use a SQL query to change them UPDATE tblCR SET tblCR.CPDadPrivate = 0 WHERE tblCR.CPDadPrivate = 1 Then the same for the mother UPDATE tblCR SET tblCR.CPMomPrivate = 0 WHERE tblCR.CPMomPrivate = 1 But again, this will change ALL persons. If when Looking at the childrens settings and the drop down list contains Private then you can change those the same way as Child Status VIEW> Master Lists> Child Parent Relationship then combine or edit your available types. Hope that helps Jay On Sun, Aug 3, 2014 at 5:15 PM, Ken Neundorf <[email protected]> wrote: There are 68,000 records that need changed. That I am not sure. From:Jay 1FamilyTree [mailto:[email protected]] Sent: Sunday, August 3, 2014 8:01 PM To: [email protected] Subject: Re: [LegacyUG] Access Database in Legacy And are you able to segregate the records you want to change somehow? Like maybe Tagging them with a specific tag? (So that when you go to update, you only change those specific records) On Sun, Aug 3, 2014 at 4:54 PM, Ken Neundorf <[email protected]> wrote: It is the Father and Mother relationship From:Jay 1FamilyTree [mailto:[email protected]] Sent: Sunday, August 3, 2014 7:44 PM To: [email protected] Subject: Re: [LegacyUG] Access Database in Legacy Ken, Also forgot to ask.... Is it just the 'main' Parent Child' relationship is Private ? or does each of "Father Relationship" and "Mother Relationship" marked as "Private" (You can have the main relationship show as anything, and then each parent relationship different like Mother Relationship = Biological and Father Relationship = Step and have that flagged as private) On Sun, Aug 3, 2014 at 4:08 PM, Ken Neundorf <[email protected]> wrote: HI, The legacy tech people told me to write to the email list and see if anyone can help me. I am in the process of cleaning up and matching two very large files so I can combine. The file that I am cleaning up has 68,000 parent child relationships marked as private. I would like to change to either biological or blank to match the file I will be importing into. Is there a way through the access database for doing this as a global change. I have a little knowledge of access but need help finding the right tables to use and what changes need made. Thanks for any help. Ken Neundorf Washington, PA [email protected] ________________________________ This email is free from viruses and malware because avast! Antivirus protection is active. 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 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 ________________________________ This email is free from viruses and malware because avast! Antivirus protection is active. 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 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 ________________________________ This email is free from viruses and malware because avast! Antivirus protection is active. 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 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 ________________________________ This email is free from viruses and malware because avast! Antivirus protection is active. 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 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
