Once you have your list of relevant John Smiths Search in that list for Individual - given names contains Mary AND Individual - spouses surname equals Smith AND Individual - birth place contains Ireland.
There are missing search criteria but many things can be found by thinking about it. The last search without preselecting the relevant John's may work, depending on the size of your database and the actual surname being searched. Cathy At 10:38 AM 17/12/2013, you wrote: >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
