zip code dilemma

[lrcarey]

Hello all,

Is it possible to have a calculation field that is looking up values from a related file that would either: a) display a value if there is only ONE related value, or drop down a list of ALL the related values?

I have a zip code file that has zip codes, towns, and states. When the user types in a zip code in the main file, it automatically pulls in the related town and state. However, our area is small enough that there are several places where multiple towns are covered by one zip code. As I currently have it set up, typing in a zip code will pull in only the first related value, but it might not necessarily be the correct one.

Any suggestions? Thanks in advance,

Leah

[danjacoby]

You can set up the "City" field as a popup list and define the value list as containing related values based on the "ZipCode" relationship. It won't auto-enter a value in the "City" field, but it limits the choices to the correct possibilities.

The "State" field can, of course, auto-enter based on the zip code, since each zip code ... ahhh, you know this.

[lrcarey]

Thank you!

Leah