You can set up a table of states where one field is the name or postal abbreviation of the state's name and a second field identifies the region in which it lies. Then a relationship matching up by State Name or state abbrviation makes it possible to add the region field from this related table in order to display/identify the region in which the state is located.
Thoroughly confused by this. I have tried what you said, but I am getting errors all over the place. Can you write it out in a step by step fashion? There must be something I am missing here. Thanks in advance!
I'll use the postal abbreviation option.
Set up a table, StateRegions with data such as:
State Abb | Region
I'll call the table where you enter or select a state, "Main". Define this relationship:
Main::StateAbb = StateRegions::StateAbb
Then you can place the Region field from StateRegions on a layout based on "Main". When you enter or select CA for California in the Main::StateAbb field (don't use StateRegions::StateAbb), the Region field will disply "West". If you enter NH, you'll get Midwest Northeast and so forth...
Woo Hoo! Thanks so much. That did it for me. This was a bit above my FileMaker skill set, but your directions were top notch! Thanks again!