William Hindman
wdhindman at dejpolsystems.com
Mon Feb 19 21:07:44 CST 2007
...you did that the last time, eh ...wrapped them up and sent them back c.o.d I did :) William Hindman ----- Original Message ----- From: <artful at rogers.com> To: "Access Developers discussion and problem solving" <accessd at databaseadvisors.com> Sent: Monday, February 19, 2007 7:51 PM 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 >