Change Dropdown values on a simple list
Could you let me know if it’s possible to change dropdown values on a simple list on the basis of the value under another simple list. For example – if list 1 has value Y, then the dropdown for list 2 should show as B, C and if suppose list 2 has value Z then the dropdown for list 2 should show as D and E and like that.
Please suggest some approaches.