dynamic drop downs per each record

[jacob94]

I thought this would be easy but I can't find anything on it anywhere. I am try to build a web form in asp using sql 2000 as the back end. i have two tables:
tblContest
QID Q
1 Who won the game?
2 Who has the most points?
3 What was the high score?

tblContest_DropDowns
QID Choice
1 red
1 blue
2 joe
2 john
3 50
3 100

I would like the form to display the questions and then the corresponding choices would populate the dynamic drop downs.

1 Who won the game? choice red/blue
2 Who has the most points? choice joe/john
3 What was the high score? choice 50/100

I need to use drop downs for each record and their could be more than 2 choices. I have the database part down and can easly display the data in a dynamic table/repeat region in DreamweaverMX. Any thoughts on how to layer in the looping select list???

 

[Sheco]

Did you try doing it so the mail loop moves through a recordset of the questions and then, inside the main loop, fetch a recordset of all answers for the current question, and then loop through the answers.

 

[jacob94]

Anyway you can provide me with an example. I do not know how to do what you described.

 

[johnwm]

I notice that you've asked nearly 50 questions, and haven't yet marked any answers as being valuable to you. If the answers aren't valuable then read faq222-2244 to see how to ask better questions. If they have been valuable, read faq222-2244 to see how to recognise that.

The FAQ will also guide you in your own basic research. In this case try

http://www.w3schools.com/vbscript/vbscript_looping.asp

to get you started.

If you then have a specific problem, come back so we can help with the detail.

___________________________________________________________
If you want the best response to a question, please check out FAQ222-2244 first.
'If we're supposed to work in Hex, why have we only got A fingers?'
Drive a Steam Roller
Steam Engine Prints