I've a list where I've two drop downs, and I want to make the drop down list options in the second column dependent on the choice made in the first. So for example:
Column A is a drop down with options 1, 2, 3.
Column B is a drop down with options A, B, C, D, E, F.
Let's say I want some logic so that if the user selects 1 from Column A, they can only select A or B in Column B. If they select 2, they can only select C or D, etc.
What's the best way to design this? Is there appropriate syntax to accomplish this in the column validation field for Column B? Is this something that's easier done using InfoPath form controls?
Any help would be much appreciated!!!