How set up a Questionnaire

[ridgerunner]

I need to set up tables and a form to allow multiple records to be built at
the same time, and I am not quite certain how to start. The form is like a
questionnaire and the data entered is a numeric score given in response to a
question. I would like the person completing the form to be able to see more
than one question at a time. Where or how do I set up the questions and how
do I pull them into the form?

 

[Douglas J. Steele]

For an example of a properly designed questionnaire application, check Duane
Hookom's "At Your Survey" at
http://www.rogersaccesslibrary.com/Otherdownload.asp?SampleName='At Your Survey 2000'

 

[ridgerunner]

Thanks. This is a good example. I am not certain if my "Categories" can be
considered the same as the levels in the Survey application and whether or
not all the questions should be in one table or broken out into separate
tables by category.

 

[Douglas J. Steele]

Separate tables by category would likely not be a good idea. You can add an
additional field to the questions table to be able to sort them by category.

 

[ridgerunner]

Thank you. This helps me a great deal.

Separate tables by category would likely not be a good idea. You can add an
additional field to the questions table to be able to sort them by category.

 

[ridgerunner]

I am in way over my head with this. I cannot determine how to make more than
one question display on the form. Are there more step-by-step instructions
anywhere?

 

[Douglas J. Steele]

I haven't seen any.

My suggestion would be to post a new question. Give an outline of what
tables you've got in your database (their names, their primary keys and the
names of the important fields in them, as not everyone will be familiar with
Duane's data model), explain what you're trying to accomplish, what you've
tried to date, and what happened when you tried. If you got any error
messages, report them verbatim. If you didn't get any error messages, but
you didn't get what you wanted, report what you got, and what you wanted to
get instead.