[libreoffice-users] Re: Auto Filling Drop Down Boxes

On 09/22/2011 01:40 AM, Andreas Säger wrote:
> Am 21.09.2011 19:00, stripedtomato wrote:
> > I have three drop down boxes: City, State, Zip as part of an address record.
> > As of now, I have to make independent selections for each of these drop down
> > boxes.  What I would like to do is when selecting a city from the drop down
> > box list, then related state and zip information would automatically be
> > filled in, in their respective drop down boxes, and the information stored
> > in their respective db cells.
>
> This is impossible because big cities have more than one ZIP and there 
> are ambiguous city names.

Actually it's not if you have (in the US) the USPS 5 digit Zip Code
database:

https://www.usps.com/business/address-information-systems.htm#

Five-Digit ZIP® Product

Provides 5-digit ZIP Code data that can be appended to computerized
mailing lists via address-matching software.

With that (or similar) I think that you could easily build a dropdown
that links to that. You'd probably need to fine tune by address as each
city, street, business may have differing Zip/Postal Codes

Unfortunately the USPS doesn't offer an easy way to order:
For more information on the AIS View, please contact the National
Customer Support Center at 1-800-238-3150, Option 6 and then Option 2 to
speak to a customer service representative.

> You may enter a city name and then choose the actual city and zip from 
> suggested data.
>
> I use to enter zip codes. Each zip code belongs to one particular city 
> in one state.
>
> Apart from this, big companies and public sectors have their own zip codes.



-- 
For unsubscribe instructions e-mail to: users+help@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted