related drop-down lists

[ZNB]

I have two dropdown lists whose contents are extracted from a database.

But I would like that when I select a value in the first, the content of the second adjusts because according to the choice in the first list, I will not have the same elements in the second.

illustration: display the department of a selected region. So I have a database with two tables, a table for the regions, a second for the departments. By selecting a region in the first list, I will display the second list corresponding to the departments of the selected region.

Tank you

[WolfShade]

Easy to do, but it won't be a strictly CF solution.  You have to use JavaScript (or jQuery) to do it.

Basically, you load the page with the first select fully populated by the database.  The second select should have no options.

Set the onChange of the first select to use AJaX to make the call to a .cfm or .cfc that will get the related department based upon the value of the region select, and then add the options to the second select.

HTH,

^ _ ^

[ZNB]

Do you have an example for this to be more meaningful?

cordially

[WolfShade]

Hi, ZNB,

Raymond Camden has an excellent blog post about related selects.  This example is using jQuery.

https://www.raymondcamden.com/2011/05/05/Related-selects-in-jQuery-an-example

HTH,

^ _ ^