Three levels cascading lookup?

[jflegras]

With the last 2.6 version of Forms (On Prem), I'm trying to do a three levels cascading dropdown :

States List

State : Text Dield

Regions List

Region :Text Field

State : Lookup Field

Cities List

City : Text Field

Region : Lookup Field

Customer List

In the form, I have three lookup list fields to choose step by step the city (states, region, city)

• The first lists all states
• The second lists regions filtered by state(no problem)
• The third lists cities filtered by region (no result)

I tried some tests :

• If I filter cities based on a text box where I enter manually the region, it's ok.
• If I filter cities  based on the first field, it's ok.

(In fact, I wanted to just measure performance of the list lookup without page refresh : fetch almost 900 cities from 36.000 in 500ms. Awesome!!!)

[#2]

Hey Jean-Francois, our Tech Evanglelist Sean Fiene​ is in the process of creating a blog post on this exact scenario Will post here once it's up!

[#3]

Here you go Three-Tier Cascading Drop Downs: Do Go Chasing Waterfalls! 

[jflegras]

This is exactly what I was doing but I had a strange problem with a lookup field.

I found the problem with CAML Query Helpder, create a new field and now everything works fine.

Regards

[andrewg]

Hi Jean, Looks like everything worked out. Please mark Emily's or your response correct for others to find a solution with similar needs.

Thanks!

[#6]

Trying to achieve below, really appreciate the suggestions for case 2

Scenarios      

             case1    case 2   case3

• List A:   breakfast   dinner   dinner
• List B:   sandwich   pizza      chicken
• List C:   water          .....            tea

for cascading downdown in form: for above case 2, the 3rd cascading drop down shows, please select a value... ( for this dropdown, you will not have any value to show as this combination doesnt have any value as seen in above case2)

• My question is how to achieve this, in case 2 , in seen in screenshot below, 3rd cascading dropdown doesnt have any value depending on the selected values . soit  shouldnt even display the third cascading at all( as this combination doesnt have any value for the 3rd cascading dropdown to show)

case3:

Case2:

Really appreciate answers