3 tier lookup, duplicates and then missing values

  • 24 April 2019
  • 1 reply
  • 6 views

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:

1665i6C146FE8A40619DD.jpg

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:

1666i1C2234212FE00224.jpg

 

 


Reply