Dennis, I have a huge smile and kinda giggling to myself. Thanks, that made my day :-D
Tim Dennis M. Kowallek wrote: > On Sat, 27 Feb 2010 13:41:03 -0600, James Cook <[email protected]> wrote: > > >> Ah, that's the trick and motivation behind putting cemetery names and >> addresses in the location list. That bit of information is much more >> helpful than 'it depends'. Good to know. >> >> I think I'd like to play with accessing the DB directly before going >> through and adding locations for cemeteries like that. I've seen a >> few thank you notes in the archives for sharing the Access Tables >> info., but can't seem to find the actual message that shared that. >> Who and where is the website that has the table relationships? That's >> be very helpful indeed. >> > > Where do you place "Oklahoma" in the Address Record? In the > State/Province field? If so, this query might work... > > SELECT tblIR.IDIR FROM tblIR INNER JOIN tblAR ON tblIR.IDARBuried = > tblAR.IDAR WHERE (tblAR.State="Oklahoma") > > Note for Tim ... are you happy now? ;-) > > 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 To unsubscribe: http://www.LegacyFamilyTree.com/LegacyLists.asp
