Hi experts, I am developing three tables: Division, State and City There are multiple divisions, states, and cities as records. First, I created records in Division: North and South. Then, state records like name of states and also records for cities. For example, ABC (east) and XYZ (west) in Division table. In table in State, I created a field to look up a value in Division and I know how to do it by making the field as number, lookup to division table and select it later.
The QUESTION:
When entering records for cities, I created a field with the lookup of which states and this is also easy as it is the same as looking up division as in the State table. However, I also need tohave division to automatically entered if you select the State since the Division in already in State table. How do I write it on City table?
Example:
Division:
1 east
2 west
State
1 California, division = west
2 New York, division = east
City
1 San Francisco, State = California, Division = West (automatically) entered since it is on table State already. How to do it to automatically entered -- OR -- to select the Division based on State input?
I would appreciate of all of you to share this knowledge.
Thank you,
HA
The QUESTION:
When entering records for cities, I created a field with the lookup of which states and this is also easy as it is the same as looking up division as in the State table. However, I also need tohave division to automatically entered if you select the State since the Division in already in State table. How do I write it on City table?
Example:
Division:
1 east
2 west
State
1 California, division = west
2 New York, division = east
City
1 San Francisco, State = California, Division = West (automatically) entered since it is on table State already. How to do it to automatically entered -- OR -- to select the Division based on State input?
I would appreciate of all of you to share this knowledge.
Thank you,
HA