Hello,

I am trying to normalize my database by following some of the forum threads on the topics. However, Im getting a little confused

I have created the following Questions Table (My answers will go in a seperate table)

tblQuestions
QuestionID - PK
QuestionnaireTypeID - FK from tblQuestionnaireType
QtypeID - FK from tblQtype - listing Y = Yes/No, N = Numeric, T = Text
Qorder - The order the questions should appear, for that particular Quesitonnaire Type
Question - The actual text of the question

Some of my questions are in "Option Groups" - with for example 3 different options (radio buttons), or they will have a combo box with a number of different answers... How should I represent these in this structure?

Do I need to create a new table listing what the options are? (which seems messy - and doesnt seem to achieve the objectives of normalization), should I create a new column in my tblQuestions to group related questions together? (subgroups of questions...in which case I would need an additional subgroup "order" field? How would I deal with the mutually exclusive nature of these questions?) Does this make any sense??

Thanks for any help
David

It sounds like you need a table to hold all of the possible response choices.

tblChoices
pkChoiceID
txtChoiceDesc


Then you will need a junction table that links the questionID with the possible choices for that queston

tblQuesChoices
pkQuesChoicesID
fkQuestionID
fkChoiceID

Thanks... I like that idea...I will "make it so"

Have a great day and thanks again for your time.

David

Did you look in the Code Archive? I posted a Survery/Questionnaire demo there some time ago.

David,

Along with checking out Noah's demo, check out this link on questionaire data models:

http://www.databaseanswers.org/data_models...mplex/index.htm

thats just one of the 3 on that site.

Good luck,

Aqua