Auto-Enter city/state with zip code

[GodURmyall]

I have a database of our city's youth who attend our church's community outreach functions. 90% or more of those kids all have the same city/state/zip. What I want to be able to do is to input ONLY the zip code and have the fields for city and state fill in automatically, but only if I enter ONE particular zip code.

I'm basically looking for an "if/then" function. If zip code A is entered, then city B and state C are entered automatically. If any other zip code is entered, city and state are filled in manually.

I'm brand new to Filemaker and would greatly appreciate ANY help. Thanks. <>< Cliff

[Genx]

... in to your auto enter calc... if(zip = "22992"; city ; "" )

[Ender]

There are a number of Zip Code databases out there on the internet, some free, some for a small fee. If you can locate one (or make your own based on your service area,) you can have a Zip Code table that also has City and State fields. Then use a relationship between your table's Zip Code field and the Zip Code field in the Zip Code table, and give your City and State auto-enter calcs to pull in the correct City and State from the related table.

Although, unless your city is on the border with another state, in most cases the State entry would be the same, and could be a simple auto-enter text entry.

[Genx]

... yes you could setup a city / zip / state table with look up fields or autoentered values according to a relationship you could set up... but if all you really want is the one zip code... you could just use the one autoenter option...

genx