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:
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:
PK - SurveyID
FK - ClientID
PK - QuestionID
FK - SurveyID
PK - AnswerID
FK - QuestionID
Does that make sense? If you need more clarification, please ask...
This post has been edited by iddimu: 20 September 2008 - 12:22 PM