Hi there
I've been busy trying to set up an example of a cascading dropdown (dependent combo box), but I'm no SQL expert and am struggling converting form Demo 11 into something that actually works.
The problem with Demo 11 is that the tables that are referenced are not visible so I can't see what's really going on.
What I want is just get the working SQL queries using the default DNN Country and Region lists as an example. i.e. Select USA off the country dropdown and have it populate the second dropdown with the regions (states)
I can make the first box work using the following:
Select '' as QuestionOption, '-1' as QuestionOptionValue
Union All
SELECT Text As QuestionOption, Text As QuestionOptionValue
FROM Lists where ListName= 'Country'
ORDER BY QuestionOption ASC
Select '
(the forum will probably mess that up)
But I can't figure out the SQL for the second dropdown.
I'm sure once I get this working, then I should be able to create other lists and get similar results.
Any assistance is much apprecated.
Regards
Rob