I am trying to cross-reference a command code with a geographic location. I want the user to select the command code and the geographic location will populate with the correct location for that command code. The problem is that there are many command codes for each geographic location.

for example:

Geographic Location: DBB
Command Codes: 100, 101, 102, 103, 104, 105, 106, 107, 108, 109, 110

Geographic Location: DBBX
Command Codes: 1,5,6,7,9,10,13,14,17

etc, etc.....

I want my user to select, on the form, the Command Code for the specific entry they are making, and I will have access supply the appropriate Geographic Location.

Thank You.