Filter Drop Down Menu
Filter Drop Down Menu
In FormA, I have 2 drop down menus.
The first drop down, DropDown1, is the Batch No.
The second drop down, DropDown2, is the Student Name.
In FormB, I put DropDown1 and DropDown 2 as lookups from FormA.
What should I do in FormB, if I select Batch No. = 20, then the DropDown2 only display the respective students from Batch 20?