I am curious to know, can you change the values/options available in drop down menu #2 based on what selection you make in drop down menu #1?
I know you can change the value of a field by selecting a certain value in another field, but what I want to do is make it so that:
1) When I select X value from drop down menu #1
2) Drop down menu #2 changes its list of values based on the selection I made in drop down menu #1.