One drop down field affects another.
Alright, here is what I am trying to do.
I have two drop down fields (Lets call them Field A and Field B for simplicities sake). What I'm looking to do is have the value selected in Field A change what value list is used for Field B. IE: If the value list for Field A has values 1, 2, and 3, and the slected valuse is 2, then I'd like Value List 2 is used in Field B. But if Field B is changed to value 1, then Field B should change to using Value List 1.
How would I go about setting this up?