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
