Yes...I thought that would be the case but the detailed search tool does not have the address fields for the four blue plus sign address items even though it does allow searches on the notes fields for those same links. By the way, I did check GenViewer again and it too does not currently allow searches on these four address fields. These four "hard-coded" events are handled in the database different than all the other events.
This is an example SQL script that I use to find these problem burial addresses. In my database, there are two cemeteries named "Franklin Cemetery"...one in Idaho and one in Pennsylvania. By comparing the burial place with the burial address, I was able to find those that needed to be corrected. I would run it again substituting Pennsylvania for Idaho. SELECT tblIR.IDIR, tblIR.GivenName, tblIR.Surname, tblIR.BirthSD, tblIR.IDARBuried, tblAR.AddrName, tblAR.State, tblLR.IDLR, tblLR.Location FROM (tblIR INNER JOIN tblAR ON tblIR.IDARBuried = tblAR.IDAR) INNER JOIN tblLR ON tblIR.IDLRBuried = tblLR.IDLR WHERE (((tblAR.AddrName)="Franklin Cemetery") AND ((tblAR.State)="Idaho")); Ron Taylor --- On Wed, 6/13/12, Ron Ferguson <[email protected]> wrote: > From: Ron Ferguson <[email protected]> > Subject: Re: [LegacyUG] search for burial address > To: [email protected] > Date: Wednesday, June 13, 2012, 2:49 AM > Ron, > > The fact that you had used the blue plus sign to enter the > address had not > registered with me when I previously replied. I had, > therefore, been > considering locations, rather than addresses. I do not use > the latter so > cannot be certain about my next comments, but it seems to me > that, perhaps > depending on how you have set up your addresses, you should > be able to > search using the Address searches, possibly the Address Name > in conjunction > with one of the other Address fields. > > Ron Ferguson > http://www.fergys.co.uk/ > > -----Original Message----- > From: Ron Taylor > Sent: Wednesday, June 13, 2012 5:02 AM > To: [email protected] > Subject: Re: [LegacyUG] search for burial address > > Sorry about adding to the other post...I got lazy. > > The problem is as follows: > > tblIR.IDLRBuried links to tblLR and can be searched with > "Burial Place" > > tblIR.IDARBuried links to tblAR and can be searched with > "Notes-Burial" but > can not be searched with "Address-Burial" because that field > is not > available in the pull-down "where to look". > > The first is the burial location and the second is the > burial address. The > same search limitation exists for birth, christening, and > death addresses. > It is interesting because Notes-Birth, Notes-Christening, > Notes-Death, and > Notes-Burial can be searched from the linked tblAR. > Ron Taylor > > > > > 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
