database design for survey

Hello Amy,

If you found a path forward in the above, please ignore this. If not:


I think that you have two different types of entities that you are using the
same word ("question") for. If you have "a" question the needs four different
answers, most would call that 4 questions. So maybe you have a "group of
4 questions". Or a "question" (that needs/has no overall answer) with 4
"sub-questions" that need/have answers. In any event, you would need to
clarify that to yourself (and to the forum to get help) because those two
types of entities would need to be recognized and dealt with in the DB
design. Hope that helps a littleFred