How to structure this.....

K

Kevin

It sounds like you would need two tables and a main form
with a subform. The first table would have the question
being asked and anyother generic question type
information. You would need a question ID that is unique.
You could use an autonumbered field here if you like.

Then you would have a table for the corresponding answers.
You would also need the question id in this table.

In the form, you would have the question and any other
correpsonding information and the subform would have the
answers. This way, if the questionaire changes, all you
have to do is add the new question and appropriate
answers. If you questions that have one answer or 20
posasible answers it would not matter, this would address
it.

As far as the comments, if they have the option of adding
comments for each question, you could have a field in your
question table. If they would only be able to have one
comment for the whole questionaire, you would probably
need another table with just that information. Without
knowing more about what your doing, it's hard for me to
address the problem.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top