questionnaire population (1 Viewer)

[CJBIRKIN]

Hello

some help was kindly given to me regarding the normalization of a questionnaire


i chose to go with the structure



tblQuestion
-- QuesNumber (PK)
-- strQuestion

tblQuestionnaire
-- QuesnairNum (PK)
-- strDescription

tbl QuesQsnair
-- QuesNumber (FK) 'this question appears on ....
-- QuesnairNum (FK) 'this questionnaire

tblAnswers
--staff_id (PK element 1) 'unique ID to show who answered
--QuesNumber (PK element 2) 'the question
--QuesnairNum (FK) ' the questionnaire this question belongs to
--strTheAnswer


my problem now is i can't see how to populate the table answer.

Ideally i will have a main form to select the staff member and 10 sub forms one for each questionnaire.

Each sub form would display all the questions in that questionnaire and the user would be able to select an answer for each question from a drop down list/combo.

As each question is answered the tbl answer would have to have a new record of staff_id the question the questionnaire and the answer

I just can't see how to do this from this table structure.

Any help would be greatfully recieved

Chris