I have an application that I am attempting to build that when an item from a dropdown list is selected, would fire off a different sql query that is dependant on the item chosen in the initial dropdown form. I really don't know where to start with this problem, as it has to be repeated 10 times if data is present to populate other form fields. Please Help!!!

Sounds like you need an onChange event in your <select> tag. Something like:
OnChange submit the form and reload the page rendering sql relating to the selection chosen?

The following would be an example of lets say a product listing page. We have a bit field in the products table called 'inactive' When the page runs initialy the ELSE condition runs showing all active products. If we choose 'Show Inactive Products' from the select list the page reloads and runs the if condition showing all inactive products.

<% if request.form("displayType") <> "" then
       sql = "SELECT ..... FROM Products WHERE inactive=" & request.form("displayType") & ";"
    else
       sql = "SELECT ..... FROM Products WHERE inactive=0"
    end if
%>


<FORM NAME="displayForm" METHOD="Post" ACTION="somePage.ASP">
 <SELECT NAME="displayType" SIZE="1" onChange="Javascript:displayForm.submit();">
  <option vlaue="0">Show Active Products</option>
  <option value="1">Show Inactive Products</option>
 </SELECT>
</form>

Wind is your friend
Matt

If the data is small enough to be handled client side then something like http://www.greggriffiths.org/webdev/...nkeddropdowns/ may work for you.

alternatively you may have to do a POST / GET back to the server of the entire page - or you could use a hidden IFrame - or just use XML.

Both of these solutions work great, but what about repeating the process 10 times with just one initial selection box. When one selects an item in dropdown box "A" then all ten Dropdown boxes ("B")need to show the same selections dependant on "A"?

busher

Seems I mis understood your post. You want to populate other selection boxes not page content? Both ways would work, if you’re not proficient in JS the way I suggested would be easier to code however Greg’s suggestion would be more resources efficient. May I suggest you have a go at building the page, if and when you get stuck the helpful people around here I'm sure will assist you.


Wind is your friend
Matt