Hello all, here is the situation I have two dropdown lists and I need the second dropdown lists values to be from
whatever the first dowpdown selection was. Just to let you know the values in the dropdown list are comming from a table in sql server.(ie a states dropdown list would have all the states from the states table in sql server) Now I know how to do this if I submit the form and capture the value of the first dropdown, then send that value to some stored procedure which returns what I want in my second dropdown list. It works no problem. But here is the issue. The form the dropdown list is on has about 13 input boxes so when I do it the way that I stated above I would either have to write a cookie to hold the values so when they select the first selection from the first dropdown and the form submits I can put the values back into the input fields or put the values into the url and do a request.querystring for the values. This sound like to much work for me so there has to be a way of doing this without submitting the form....
Thanks,
Frandazzo
whatever the first dowpdown selection was. Just to let you know the values in the dropdown list are comming from a table in sql server.(ie a states dropdown list would have all the states from the states table in sql server) Now I know how to do this if I submit the form and capture the value of the first dropdown, then send that value to some stored procedure which returns what I want in my second dropdown list. It works no problem. But here is the issue. The form the dropdown list is on has about 13 input boxes so when I do it the way that I stated above I would either have to write a cookie to hold the values so when they select the first selection from the first dropdown and the form submits I can put the values back into the input fields or put the values into the url and do a request.querystring for the values. This sound like to much work for me so there has to be a way of doing this without submitting the form....
Thanks,
Frandazzo