+1I 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.
+23Hi,
I gave this a go and was able to acheive the solution.
My database.
Configuration of the Parent control which I named "Country"
Configuration of Child control which has a reference to the Named Control Country.
Result on the form.
+1Simon, 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.
Configuration of the Parent control which I named "Country"
Configuration of Child control which has a reference to the Named Control Country.
Result on the form.
@SimonMuntz wrote:Hi,
I gave this a go and was able to acheive the solution.
My database.
Configuration of the Parent control which I named "Country"
Configuration of Child control which has a reference to the Named Control Country.
Result on the form.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
