[AccessD] combo from multiple sources

Well done. But the next time you call me Art, I shall send some 18th street gangers to drive by your house.

 
Arthur Fuller
Technical Writer, Data Modeler, SQL Sensei
Artful Databases Organization
www.artfulsoftware.com




----- Original Message ----
From: William Hindman <wdhindman at dejpolsystems.com>
To: Access Developers discussion and problem solving <accessd at databaseadvisors.com>
Sent: Monday, February 19, 2007 7:23:05 PM
Subject: Re: [AccessD] combo from multiple sources


...I've gone a step further Art ...I now have a tblGeo in my templates which 
holds unique info relevant to a geographical location including GeoID, 
PostCode, CityID, Prime, CountyID, StateID, NationID, RegionID, longitude, 
and latitude ...I moved to this format to resolve differences in worldwide 
postal addressing and then added long/lat to be able to target addresses 
within circular references when that need cropped up ...the GeoID becomes 
the fk in any query requiring address/location info.

William Hindman