Hi all -
I am trying to write some code to handle a survey. I need some advice on how to layout my tables/handle the survey answers.
I would have no problem with it if they were all multiple choice / yes-no type questions...my problem (and serious confusion) comes in when there is this:
CODE
10. Can you say why you didn't use any medication?
- Didn't want to
- Didn't try
- Medical Reasons
- Pregnancy
- Financial Reasons
- Difficult to obtain
- Ins. doesn't cover
- Other _____________________
The possible selections in the above question are all checkboxes - so one to many can be selected. I could probably figure out how to handle that alright, but I'm getting thrown off by the "Other" selection.
Would I need to use a separate table for every question that has an "Other" option? That would seem kind of strange, but I'm no database expert by any means
What about this:
tblSurvey
PK - SurveyID
FK - ClientID
tblQuestions
PK - QuestionID
FK - SurveyID
Question
tblAnswers
PK - AnswerID
FK - QuestionID
Answer
???
Does that make sense? If you need more clarification, please ask...
Thanks!
This post has been edited by iddimu: 20 Sep, 2008 - 11:22 AM
20 Sep, 2008 - 11:21 AM
.
| 