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? ;-) -- Dennis Kowallek (LTools) http://zippersoftware.com/ltools http://groups.yahoo.com/group/ltools 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
