Updating drop-down list, based on selection from another d-d list

[CJM]

Not sure if this is entirely on-topic....

I would ideally like to present an initial list based on one DB table. The
user selects an item, and the 2nd list is updated to show items from the DB
related to the first selection.

As I understand it, there are a number of possible solutions, but I dont
know much about any of them, nor which is currently the recommended route.

This is going to be applied in an intranet application, so it gives me a bit
of freedom to use the technology I wish, but if there is an accessible
solution (as in WAI) that would be great.

Thanks

[CJM]

"[MSFT]" <lu******@online.microsoft.com> wrote in message
news:kV**************@cpmsftngxa06.phx.gbl...

Hello,

Thank you for using the community.

Regarding the problem, we can retrieve the records from database with ADO
and fill it in DropDownlist control. Once User select one in the first
dropdown list, the form will be submit and we can requery the database to
fill second dropdownlist. Here is a good sample on this issue, you may
refer to it:

http://www.designplace.org/tutorials.php?page=1&c_id=26

Luke,

Thanks but I wasn't clear enough in my explanation.

I want to avoid having to post the form...

I have a solution (not finalised yet); I'm using javascript and XML Data
Islands:

The user makes a selection from combo1. Javascript is used to call and asp
page which returns an XML structure, which the Javascript uses to populate
the 2nd combo.

Thanks

Chris

[[MSFT]]

Hello,

Thank you for using the community.

Regarding the problem, we can retrieve the records from database with ADO
and fill it in DropDownlist control. Once User select one in the first
dropdown list, the form will be submit and we can requery the database to
fill second dropdownlist. Here is a good sample on this issue, you may
refer to it:

http://www.designplace.org/tutorials.php?page=1&c_id=26

Hope this help,

Luke
Microsoft Online Support

Get Secure! www.microsoft.com/security
(This posting is provided "AS IS", with no warranties, and confers no
rights.)

[[MSFT]]

Hi Chris,

This is also nice solution (Javascript and XML dataland). Within this
approach, all records will be sent to client at beginning. For more
information about XML data island, you may refer to:

http://msdn.microsoft.com/library/de...us/xmlsdk/htm/
xml_concepts2_2n03.asp

If you have further detail question on this, please feel free to post here.

Regards,

Luke
Microsoft Online Support

Get Secure! www.microsoft.com/security
(This posting is provided "AS IS", with no warranties, and confers no
rights.)