Re: [LegacyUG] Searching criteria

2013-12-16 Thread Cathy Pinner
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 las

Re: [LegacyUG] Searching criteria

2013-12-16 Thread Ron Taylor
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,

Re: [LegacyUG] Searching criteria

2013-12-15 Thread David Newton
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: >

Re: [LegacyUG] Searching criteria

2013-12-15 Thread Jenny M Benson
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 >

[LegacyUG] Searching criteria

2013-12-15 Thread Cliff Gittens
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 bir