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: [email protected] 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
