Conditional Drop Down Lists
I have a database with which I would like to have a conditional drop down list based on the choice in another field.
Here is my example data:
Location A Site A
Location A Site B
Location B Site C
Location B Site D
In a sepreate table I have many fields but also Location and Site. I have defined a relationship for Locations between the two tables. What I would like to do next is have a "conditional" drop down list in the second table for Sites that depends on my choice for Locations:
If I choose Location A, I would like the drop down to display only Site A and Site B
If I choose Location B, I would like the drop down to display only Site C and Site D.
Any help would be greatly appreciated.