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.

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?

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.

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

Here is a great solution to your problem.

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

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

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