related drop-down lists

Question

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 · Answer

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,

^ _ ^

Sign up

To post, reply, or follow discussions, please sign in with your Adobe ID.

Sign in to Adobe Community

To post, reply, or follow discussions, please sign in with your Adobe ID.