need some help

[saraswati]

Hi ! I have 2 fields State and Zip Code.

When a user enters State information for a new record I want the corresponding Zip Code to be automatically displayed in the ZipCode field. I have a drop down box for the user to choose the State. Once the user chooses the State I have to automatically put the value of that State's Zipcode in the ZipCode field. Please tell me how to go about this.

[jasonwood]

ummmm... I'm not from the US but wouldn't each state have a LOT of zip codes? Sure you don't want to go the other way around?

[docfx]

It would be far easier to pull over a city and/or state/prov, given a zip/postal code. In the US, the 1st three digits only narrow it to an area of the state. There is no code good for the entire state.

You can enter a zip and pull up the city or state. Have a separate file with both fields correctly populated w/ the appropriate info and use a portal ro do a simple lookup.

It is possible use filemaker to enter a city or state and populate a subesquent pop-up list for the user to select but it can get quite convoluted and can be slow. We've done it in the past for a couple clients that wanted to selectively narrow subsequent field choices (part numbers) based on their selection to a previous field (prod categories). Also there is a filemaker limitation of number of files open at a given time - given the number of cities and/or states, this could be a problem getting it all set up.

[Dr. Logan]

Sounded like you might have meant to say enter a zip code and the city and state would be filled in automatically. I recently implemented this feature for a foster agency intake DB in California. I will attach a csv text file to this message for you to download and import into FM.

All that is required is a simple relationship between the two dbs with lookups for the city, county, and state.

Hope this is helpful.

ZipCodes.zip

[Ocean West]

Here is a great solution to your problem.

http://www.briandunning.com/zipcodes/

[Lee Smith]

I downloaded the attactment to your message, and found it to be "Password" protected FM file instead of "a csv text file" as mentioned in your message.

Am I missing something here?

Lee

[DanBrill]

Dr Logan,

The file you posted is password protected. Can you repost without the password, or clue us in on what it is?

Thanks,

Dan