[AccessD] combo from multiple sources

You'd be going easy on ol' Billie boy there... ;)

Drew

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of
artful at rogers.com
Sent: Monday, February 19, 2007 6:52 PM
To: Access Developers discussion and problem solving
Subject: Re: [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
-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com