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

Hi :)
I think Andreas was just pointing out that given a zip code it might be fairly easy to find the 
city, State and such but given a State or even a specific city it might not be easy to guess which 
of the zip codes is right.  I think you can get part of the zip code that way buit not all of it?  
In England the first 2 letters give the 'State'/County (well, approximately).  

Anyway the technical part of the question is how to get one drop-down to look-up and fill in a 
value based on the entry made elsewhere on the page.  Is Chapter 8 or 10 in the Calc Guide helpful?
http://wiki.documentfoundation.org/Documentation#LibreOffice_Calc_Guide

Regards from
Tom :)

--- On Fri, 23/9/11, NoOp <glgxg@sbcglobal.net> wrote:

From: NoOp <glgxg@sbcglobal.net>
Date: Friday, 23 September, 2011, 3:26

On 09/22/2011 01:40 AM, Andreas Säger wrote:
> 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