database query to move to next page

[trolldude]

Hi

I am building an online questionnaire. Each users name etc. is held in an
Access database. Each user has several respondents answering questions about
them. There are 12 section pages of questions. Each user needs different
section pages answered about them. So when a respondent logs in idealy they
will move from one section to another only seeing the relevant sections.

Is it possible to insert a database query as a form post destination? So that
when the form is submitted the database is checked to see what that persons
next section is and the form is posted there. I realise I will need to have the
insert data info for all the sections at the top of each section page.

Or is there another way? Please help I have been struggling with this for
weeks.

Many thanks

Trolldude

[Dan Bracuk]

Another way is to use some sort of session variable to strore the answers in
RAM until all the questions are complete. Then process your session variable
and insert the bits into your db.

A structure would be the best choice for your session variable.