Hello: I have created a Nintex form based on 3 lookup lists (cascading), seeing an issue where list 3 has a duplicate values show up in the drop-down and some have no values to be selected. Please see my examples below. Any help would be greatly appreciated. Thanks,
Expecting the following when selecting from the 3 drop-downs:
First Selection:
Location: 1st Location
Some Number: 400
Description: Entrance
Second Selection:
Location: 2nd location
Some Number: 100
Description: Entrance
But it’s doing the following when selecting from the 3 drop-downs:
First Selection:
Location: 1st location
Some Number: 400
Description: it shows “Entrance” twice in the drop-down. Please see Image 1 below:
Second Selection:
Location: 2nd location
Some Number: 100
Description: drop-down is empty, nothing to be selected. It should show "Entrance" as expected. Please see Image 2 below:
