Use detailed search to find and set tag1 for all possible husbands. Use detailed search to find and set tag2 for all possible wives.
Use this SQL query to display marriages that have Husband on tag1 and Wife on tag2. SELECT tblMR.IDMR, tblIR.IDIR, tblIR.GivenName, tblIR.Surname, tblIR.BirthSD, tblIR_1.IDIR, tblIR_1.GivenName, tblIR_1.Surname, tblIR_1.BirthSD, tblIR.Tag1, tblIR_1.Tag2 FROM (tblMR INNER JOIN tblIR ON tblMR.IDIRHusb = tblIR.IDIR) INNER JOIN tblIR AS tblIR_1 ON tblMR.IDIRWife = tblIR_1.IDIR WHERE (((tblIR.IDIR)>0) AND ((tblIR_1.IDIR)>0) AND ((tblIR.Tag1)=1) AND ((tblIR_1.Tag2)=1)); It would be great if Millennia would provide "Where to look" fields for "Spouse's Tag1", "Spouse's Tag2", etc. in the Detailed Search. Then the SQL would not have to be executed outside of the program. Many combinations of husband/wife can be searched by adjusting the Detailed Search criteria or the Query by Example Search. Another way to find spouses by names is the Marriage List where you can sort by Husband name or Wife name and then look for the couple you want but that won't take into account the birth dates, places, etc. that can be done with the detailed search and tagging. And yet a third way to find all kinds of data in a Legacy file is GenViewer's Highlighting function. Ron Taylor On Sunday, December 15, 2013 5:42 PM, David Newton <[email protected]> wrote: A Query by Example would allow finding individuals satisfying the first 4 criteria. Then a detailed search within the results for spouse with given name Mary would take care of criterium 5 but I cannot see how to pick out the spouse birth place. David On 15/12/2013 22:18, Jenny M Benson wrote: > On 15/12/2013 21:54, Cliff Gittens wrote: >> My database is getting large and I am finding it more and more difficult >> to find people. For example, is it possible to create a search in >> Legacy that would use the following search criteria: >> >> First name: John >> Surname: Smith >> Year Born: 1880 >> Birth Place :England >> Spouse First Name : Mary >> Spouse birth place : Ireland >> >> Any ideas would be appreciated. > > You are limited to 3 Search Criteria at a time, so you would need to do > one search, perhaps for a John Smith born in 1880 and tag the people > found. Then do another search for people with that tag set who were > both in England and have a spouse named Mary. > > I'm not sure about the further criterion of the spouse's birthplace. > 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
