Dependent List Boxes in ASP

Hi, I have a page which acts as an online application form. I have the first list box populating from my SQL database and I want the second list box (or dropdown list) to populate from the database dependent on the first list box.

For example. The first list box has regions (i.e. Vancouver, Toronto, New York) and I want the second box to display job titles that are related to the region.

Does anyone know how to do this?

Thanks SO MUCH!!

Comments

List boxes

July 2, 2004 by Chidi Okoronkwo

Hi,

try this links

Self Submitting drop down with Sub Drop down.
http://www.programmersresource.com/...s=&threadid=770
This is a forum post.

Cheap Tricks 2: A Dynamically-Linked Listbox
http://www.atgconsulting.com/doublelist.asp
Initially sends all data to the page and then lets JavaScript populate the second list box.

Dependent List Boxes in ASP

October 6, 2004 by pino tuzzolino

Free extension

Dynamic Dependent Drop Down Lists

http://www.kermy.com/

Kermy extension

July 6, 2005 by Les Matthews

Does anyone know how to preselect a value from the dependent dropdown based upon a recordset value. I would like to use this in a record update form. I have no problem making the default value of the parent dropdown match a recordset, but am having difficulty doing so with the child dropdown.

You must me logged in to write a comment.