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 <[email protected]> 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 > > > On Mon, Jul 7, 2014 at 9:11 PM, Ron Taylor <[email protected]> wrote: > >> Jay, >> This first script is one that I developed to locate duplicate siblings in >> the database. These are situations where a child is given a name that the >> parents want but then dies early so they give the same name to another >> child. Sometimes more than twice. It illustrates the connection of the >> child status to the child record which is linked to the individual record. >> >> SELECT tblCR_A.IDMR, tblCR_A.IDIR, tblCR_B.IDIR, tblIR_A.Surname, >> tblIR_A.GivenName, tblIR_B.GivenName, tblIR_A.Gender, tblIR_B.Gender, >> tblCS_A.ChildStatus, tblCS_B.ChildStatus >> FROM (tblCR AS tblCR_A INNER JOIN tblIR AS tblIR_A ON tblCR_A.IDIR = >> tblIR_A.IDIR) INNER JOIN tblCS AS tblCS_A ON tblCR_A.IDCS = tblCS_A.IDCS, >> (tblCR AS tblCR_B INNER JOIN tblIR AS tblIR_B ON tblCR_B.IDIR = >> tblIR_B.IDIR) INNER JOIN tblCS AS tblCS_B ON tblCR_B.IDCS = tblCS_B.IDCS >> WHERE (((tblCR_A.IDMR)=[tblCR_B].[IDMR]) AND >> ((tblCR_A.IDIR)<[tblCR_B].[IDIR]) AND >> ((tblIR_A.GivenName)=[tblIR_B].[GivenName])) >> ORDER BY tblCR_A.IDIR; >> >> This next script will find individuals that are linked to multiple >> parents and how the relationship to each parent is linked. >> >> SELECT tblCR.IDIR, tblIR.Surname, tblIR.GivenName, tblCR.IDMR, >> tblMR.HusbSurname, tblMR.HusbGivenName, tblMR.WifeSurname, >> tblMR.WifeGivenName, tblIR.IDMRParents, tblCP.CPRelation, >> tblCP_1.CPRelation, tblCR.IDCPDad, tblCR.IDCPMom >> FROM (((tblCR INNER JOIN tblMR ON tblCR.IDMR = tblMR.IDMR) INNER JOIN >> tblIR ON tblCR.IDIR = tblIR.IDIR) INNER JOIN tblCP ON tblCR.IDCPDad = >> tblCP.IDCP) INNER JOIN tblCP AS tblCP_1 ON tblCR.IDCPMom = tblCP_1.IDCP >> WHERE (((tblCR.IDCPDad)>1)) OR (((tblCR.IDCPMom)>1)) >> ORDER BY tblCR.IDIR, tblCR.IDMR; >> >> Finally, this script will find all individuals with child status Twin and >> illustrates how the status is linked to the individual. >> >> SELECT tblCR.IDIR, tblIR.Surname, tblIR.GivenName, tblCS.ChildStatus >> FROM (tblCR INNER JOIN tblCS ON tblCR.IDCS = tblCS.IDCS) INNER JOIN tblIR >> ON tblCR.IDIR = tblIR.IDIR >> WHERE (((tblCS.ChildStatus) Like "Twin")); >> >> Hope that helps you with your quest. >> Ron Taylor >> >> >> >> On Monday, July 7, 2014 7:59 PM, Jay 1FamilyTree < >> [email protected]> wrote: >> >> >> >> When I change a child status from the default of '_' to 'TWIN', >> >> What field changes in the database? >> >> I cannot see any changes in the IR table for Individuals >> Or is there somewhere else I should be looking? >> >> Thanks for any help >> >> Jay >> >> > > > 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
