Hi All, I have 2 lists of choice menu on my form namely List A and List B and would like to auto populate of Form B choice based on choice made on Form A but maintain the flexibility on choices. Here is the example :-
List A choice : Apple, Orange, Pear
List B choice : Apple, Orange, Pear
Scenario 1 - If user choose "Apple" in list A, and list B will automatically look up and populate "Apple" as selected choice.
Scenario 2 - If user choose "Apple" in list A, and list B will automatically look up and populate "Apple" as selected choice. But user to manually change the list B selection to "Orange" instead while list A maintain as "Apple".
So most of the time List A and List B should show the identical values but occasionally user can change their choice in list B manually. I hope this clarify and appreciate any feedback or assistance received.
