Hello World,
I am trying to create a cascading combo box on one of my forms, but am lost on how to do it.
I have two tables with the following fields
Table 1 -
Countries - A, B, C, D, E, F
Table 2 -
Countries - Selected from "Countries" field of Table 1
Sites - 1, 2, 3, 4, 5, 6, 7, 8, 9
How can I create a cascading combo box where when a certain country is selected in box 1, only those sites in that country are available for selection in box 2?
I am trying to create a cascading combo box on one of my forms, but am lost on how to do it.
I have two tables with the following fields
Table 1 -
Countries - A, B, C, D, E, F
Table 2 -
Countries - Selected from "Countries" field of Table 1
Sites - 1, 2, 3, 4, 5, 6, 7, 8, 9
How can I create a cascading combo box where when a certain country is selected in box 1, only those sites in that country are available for selection in box 2?