drop down list tutorial

December 4, 2004 by Chris Charlton

Just for details, are you trying to:

1. use a recordset for the dropdown list? (dynamic dropdown)
2. use the dropdown list to call a details page from what was selected in the dropdown list?

December 5, 2004 by Jennifer Lyle

Yes I am trying to use a recorset and I want to show a results page with the data from my database depending on what the user selects from the dropdown list.

December 5, 2004 by Chris Charlton

Not hard at all. I assume you already made a recordset of what goes into the dropdown. In your recordset you'll need one parameter for the dropdown labels (shown to user), and one for values (not seen by user).

DW has the easiest implimentation for form objects - click Insert > Application Objects > Dynamic Data > Dynamic Select List, and attach your recordset to it.

Remember you'll need the dropdown menu wrapped in a form tag, with a submit button. The action attribute of the form should point to the details page, and the details page should grab the value from the dropdown list that you made for it to filter its recordset.

I wrote this short because DW is a great tool and it's pretty much as easy as that.

If you are learning about form basics check out this premium article Cornerstones: DMX Forms. If you are getting familiar with forms and ASP, then maybe would benefit from reading ASP and Forms: The Request object

Hope this helped. :)

January 10, 2005 by Chris Charlton

Cornerstones: DMX Forms, ASP and Forms: The Request object, and maybe Dynamic Menus with ASP and CSS