Jay, You are probably aware that tblCS is not standard for all users. It contains whatever the user has added or retained from the original install. So changing the value from 0 to 6 may not the "Twin" setting for all databases. What I do is determine the value I want for the specific database by looking at tblCS and then work from there. Notice in my main database that tblCS value 4 = Twin. You should also notice that "Adopted" is not in the child status table because that is a value in the relationship to parent table (tblCP). The child status table would be more correctly titled Birth Status. You will also see that I have added a few unusual child status settings. Those come into play for family groups where the same name has been used for multiple children (IDCS=22). And likewise IDCS=23 for those group sheets where somebody did not take the time to determine if a child was male or female so they just entered the name with both genders. IDCS=24 is simply a combination of 4 and 22. There could be IDCS=25 for combination of 7 and 22, etc. IDCS=1 is blank which should be considered a single live birth.
tblCS IDCS ChildStatus 1 3 Stillborn 4 Twin 7 Triplet 9 Stillborn Twin 13 Stillborn Triplet 14 Quadruplet 22 Sibling same name 23 Sibling same name opposite gender 24 Twin Sibling same name This is my child relationship to parent table. Adopted obviously belongs in this table. There has been some discussion as to whether Biological and Natural are the same thing. IDCP=1 is blank which should be considered same as Biological. On Tuesday, July 8, 2014 1:05 PM, Jay 1FamilyTree <1familytree....@gmail.com> wrote: which was What field changes in the database? Not, How to do a search... But thanks for taking the time to respond. On Mon, Jul 7, 2014 at 9:56 PM, Sherry/Support <she...@legacyfamilytree.com> wrote: That wasn't your original question! > > > > > >Sincerely, >Sherry >Technical Support >Legacy Family Tree > > >On Mon, Jul 7, 2014 at 9:47 PM, Jay 1FamilyTree <1familytree....@gmail.com> >wrote: > >Thanks Sherry, >> >> >>But That doesnt answer my question, as I intend on using a SQL search to >>update all the ones that are not flagged as twins. >> >> >>I need to look thru the fields in the CP, CR and CS tables, It must be set >>there. >> >> >> >> >> >> >> >> >> >> >> >>On Mon, Jul 7, 2014 at 9:18 PM, Sherry/Support <she...@legacyfamilytree.com> >>wrote: >> >>Isn't it easier to just do a Search on the Detailed Search tab >>> >>> >>>Look for whom? Individual >>> >>>Where to look Child Status >>>How to look Equal to >>> >>>What to look for Twin >>> >>> >>>Of course, this is assuming you have twins flagged with child status >>> >>> >>>And of course, you can find individuals with Multiple Parents on the >>>Miscellaneous tab. >>> >>> >>> >>> >>> >>> >>>Sincerely, >>>Sherry >>>Technical Support >>>Legacy Family Tree >>> > > >Legacy User Group guidelines: >http://www.LegacyFamilyTree.com/Etiquette.asp >Archived messages after Nov. 21 2009: >http://www.mail-archive.com/legacyusergroup@legacyusers.com/ >Archived messages from old mail server - before Nov. 21 2009: >http://www.mail-archive.com/legacyusergroup@legacyfamilytree.com/ >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/legacyusergroup@legacyusers.com/ Archived messages from old mail server - before Nov. 21 2009: http://www.mail-archive.com/legacyusergroup@legacyfamilytree.com/ 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 tblCP IDCP CPRelation 1 2 Adopted 3 Biological 4 Challenged 5 Disproved 6 Foster 7 Guardian 8 Sealing 9 Step 10 Private 12 Unknown 13 Family member 15 Natural 16 Paternity Papers at birth I mentioned a script that can find multiple births and help determine if the child status has been set in Legacy for each of them. Note that triplets will generate 3 lines whereas twins will only generate 1 line. Quadruplets 6 lines. The script could be tweaked to only show those with a blank child status but I like it to show all the multiple births and the status for verification that it is set right. Notice that it will also pickup those children that are entered as both male and female with the same name as described above. Only individuals with a non-blank birth date are considered by the logic. SELECT tblIR_A.Surname, tblIR_A.IDIR, tblIR_B.IDIR, tblIR_A.GivenName, tblIR_B.GivenName, tblIR_A.Gender, tblIR_B.Gender, tblCS_A.ChildStatus, tblCS_B.ChildStatus, tblIR_A.BirthSD, tblCR_A.IDMR FROM tblCS AS tblCS_A INNER JOIN (tblIR AS tblIR_A INNER JOIN tblCR AS tblCR_A ON tblIR_A.IDIR = tblCR_A.IDIR) ON tblCS_A.IDCS = tblCR_A.IDCS, (tblIR AS tblIR_B INNER JOIN tblCR AS tblCR_B ON tblIR_B.IDIR = tblCR_B.IDIR) INNER JOIN tblCS AS tblCS_B ON tblCR_B.IDCS = tblCS_B.IDCS WHERE (((tblIR_A.Surname)=[tblIR_B].[Surname]) AND ((tblIR_A.IDIR)<[tblIR_B].[IDIR]) AND ((tblIR_A.BirthSD)=[tblIR_B].[BirthSD] And (tblIR_A.BirthSD)>0) AND ((tblCR_A.IDMR)=[tblCR_B].[IDMR])); If you come up with some useful SQL please share. Maybe someday, Legacy will automatically suggest child status when siblings with the same birthdate are entered. At this point in time, we have to manually set those flags. Once they are set, then Legacy does have tools for finding them. But no tools for determining if the settings are missing like these scripts. Ron Taylor Legacy User Group guidelines: http://www.LegacyFamilyTree.com/Etiquette.asp Archived messages after Nov. 21 2009: http://www.mail-archive.com/legacyusergroup@legacyusers.com/ Archived messages from old mail server - before Nov. 21 2009: http://www.mail-archive.com/legacyusergroup@legacyfamilytree.com/ 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