allow website visitors to enter data screen by screen

[FatJackSprat]

I have a list of up to 75 questions that I would like people to enter responses to at my website. The replies go into an access db. Rather than have one screen with all the questions, I would like to break them up into 7-10 per screen.

How do I get the data from one screen to get entered into the db for the same user and with the same key or id number? I would like all the answers from one user to go into one row in the db?

I have not been able to find this in layman's terms anywhere, but I see other sites using multiple screens to collect data.

 

[stndn]

You could store the answers in hidden fields, and keep adding them up when you go from one page to another.

page 1:
Enter your name:
Enter your email:
Enter your age:

page 2:
(hidden field with name from page 1)
(hidden field with email from page 1)
(hidden field with age from page 1)
Enter your hobby:
Enter your likes:
Enter your dislikes:

Page 3:
(hidden fields with answers from page 1 and 2)
Questions for page 3 and so on

... etc.

Last page:
(hidden fields from all other pages)
-> user click submit, all the hidden values entered to database the way you want it to be.

 

[Thyme]

You can also use sessions. I don't know about ASP, but in PHP that'd probably be easier.