Questionaire table structure problem

[Shaft]

Hi All,

I've made a questionaire database as shown in the attached picture. My problem is I've got the same questions on multiple questionaires and don't want to duplicate the questions in the questions table for each questionaire.

Any suggestion would be greatly appreicated.

Thank You

 

[boblarson]

Do this for the questions and get rid of the question type table and create a new table for question scores:

QUESTIONS (table)
QuestionID
QuestionDescription
QuestionType

QUESTION SCORES (table)
ScoreID(autonumber)
QuestionaireID (FK)
QuestionID (FK)
Score

You may have to modify slightly to fit what you are doing as I'm not sure what the Response table is for. Depending what that one is for you may even be able to eliminate it.

 

[Shaft]

Thinking outside the box I like it, thank you. Oh yeah the response table is for the questionaire answers.

Cheers