Hi All
I need some help. I have three dropdown lists on a form. One master list and two dependent lists and I need them to link them. For exmaple:
Dropdow List 1 values: A, B ,C, D
Dropdown List 2 Values: If Dropdown list1 = A then A1, A2, A3
If Dropdown list1 = B then B1,B2, B3
and so on....
Dropdown List 3 Values: If Dropdown list1 = A then Andy, Amy, Ally
If Dropdown list1 = B then Ben, Bell, Bow
Any help will be greatly appriciated.
Many thanks
Ami