I would like to get a value/store into a variable chosen from a drop down box (popualted by ASP and SQL server), use this variable in a different SQL statement to populate another drop down box in the same page(popualted by ASP and SQL server, same as above), is this possible