cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Nintex Newbie

SQL Request Control Cascading Dropdown Not Working

I have created the SQL request controls for country and after selected a country will populate the cities in another SQL control. However i failed to get the list of cities after selected the country. 

I created a calculated column to display the select country, it display the France:#France. Kindly assists. 

image001.pngimage002.pngimage003.pngimage004.png

 

 

 

Labels: (1)
Tags (1)
0 Kudos
Reply
3 Replies
Highlighted
Nintex Employee
Nintex Employee

Re: SQL Request Control Cascading Dropdown Not Working

Hi,

I gave this a go and was able to acheive the solution.

My database.

Data.png 

Configuration of the Parent control which I named "Country"

Country.png

Configuration of Child control which has a reference to the Named Control Country.

City.png

Result on the form.

Form.png

 

0 Kudos
Reply
Highlighted
Nintex Newbie

Re: SQL Request Control Cascading Dropdown Not Working

Simon, thanks for your replied. Can you please share me the display value when you select the country? I tried few times still can get the list for second drop down. I used the calculated column to display the select value, it gave me France;#France. Not sure because of this it can't get the list of value. 


@SimonMuntz wrote:

Hi,

I gave this a go and was able to acheive the solution.

My database.

Data.png 

Configuration of the Parent control which I named "Country"

Country.png

Configuration of Child control which has a reference to the Named Control Country.

City.png

Result on the form.

Form.png

 



@SimonMuntz wrote:

Hi,

I gave this a go and was able to acheive the solution.

My database.

Data.png 

Configuration of the Parent control which I named "Country"

Country.png

Configuration of Child control which has a reference to the Named Control Country.

City.png

Result on the form.

Form.png

 


 

0 Kudos
Reply
Highlighted
Nintex Employee
Nintex Employee

Re: SQL Request Control Cascading Dropdown Not Working

Hi,

I get the same output as you.

SQL.png

 

0 Kudos
Reply