[AccessD] Zip+4?

David

...thanks ...comforting to know others have reached the same solution ...but 
what about the data entry? ...how do you force that?

William

--------------------------------------------------
From: "David McAfee" <davidmcafee at gmail.com>
Sent: Wednesday, February 11, 2009 12:45 PM
To: "Access Developers discussion and problem solving" 
<accessd at databaseadvisors.com>
Subject: Re: [AccessD] Zip+4?

> I do what you do. I have a table (tblCSZ) which is a list of City,
> State & Zip Code (5 digit zip).
> I store the right 4 characters (if applicable) in the address table
> along with the ZipID (PK of tblCSZ)
>
> David
>
> On Wed, Feb 11, 2009 at 9:35 AM, William Hindman
> <wdhindman at dejpolsystems.com> wrote:
>> Group
>>
>> I use a separate tblGeo table to manage
>> city/state/post/country/region/timezone/dst/lat/long data with an fk join 
>> on
>> tblOrgAddress.
>> This is presented as an enforced combo with any new org address entry, 
>> thus
>> ensuring that only valid entries are allowed for that data.
>> When US zip codes were only 5 digits, this worked quite well ...but the
>> growing number of +4 zips is beginning to grow out of control ...adding 
>> the
>> +4 means an additional 10k entries per US post code are possible ...which
>> would drive the db to its knees.
>>
>> So I've separated out the +4 and isolated them in the tblOrgAddress to 
>> limit
>> the impact on lookups and just concatenate them when I assemble 
>> addresses.
>> This is of course time and code intensive in its own right but limited to
>> only those times when a full mailing address is required.
>>
>> The problem comes in requiring data entry people to enter the +4 separate
>> from the post code ...it just isn't getting done ...and the client is now
>> seeing address rejections from the postal service bulk mailing because 
>> the
>> +4 is missing.
>>
>> Question is, does anyone have a better way of handling the zip+4 issue?
>>
>> William
>>
>>
>>
>> --
>> AccessD mailing list
>> AccessD at databaseadvisors.com
>> http://databaseadvisors.com/mailman/listinfo/accessd
>> Website: http://www.databaseadvisors.com
>>
> -- 
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>