John Clark
John.Clark at niagaracounty.com
Fri Mar 12 07:59:27 CST 2004
This is actually what I was looking at--keeping the zips and the towns seperated. Maybe I'm a closet freak myself--hmmph! John W Clark >>> rl_stewart at highstream.net 3/12/2004 8:42:37 AM >>> John, I have a table for the US with all that in it. Do you need it? For the normalization freaks (like me), here is a normalized design: tblPostalCode PostalCodeID AutoNumber (PK) PostalCode Text(10) CityID Long Integer RegionID Long Integer Unique index on PostalCode, CityID, RegionID tblCity CityID Autonumber (PK) CityName Text(30) Unique Index on CityName tblRegion RegionID Autonumber (PK) RegionName Text(30) CountryCode Text(2) Unique Index on RegionName, CountryCode tblCountry CountryCode Text(2) (PK) CountryName Text(30) Unique index on CountryName Robert P.S. The ISO standard is actually Division, if I remember correctly for the way I used region here. At 07:10 PM 3/11/2004 -0600, you wrote: >Date: Thu, 11 Mar 2004 16:55:17 -0500 >From: "John W. Colby" <jwcolby at colbyconsulting.com> >Subject: RE: [AccessD] question on normalization >To: "Access Developers discussion and problem solving" > <accessd at databaseadvisors.com> >Message-ID: <DCEFJAOENMNENLAAOFGPCEJAHCAA.jwcolby at colbyconsulting.com> >Content-Type: text/plain; charset="iso-8859-1" > >David, > >Did you fill in this table with which Zips were in which town etc.? Or is >there a standard db out there somewhere with this stuff? > >John W. Colby >www.ColbyConsulting.com -- _______________________________________________ AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com