Quality Review Questionnaire Database - Issue Linking Quality Review with Questions and Responses

[geast]

I created a database to log quality reviews. I have three basic tables: tblReviewInfo - which identifies a reviewer and review date; tblQuestions which contains approximately 50 questions with an active or inactive status; and tblQuestionResponses which contains the quality review response to the active questions in tblQuestion. I would like to create a form on which I can start a new quality review (using tblReviewInfo), links and populates the active questions to be answered during each review, and finally, permits me to answer each of the active questions (using tblQuestionResponses) for each new quality review (using tblQuestionResponses). I have tried linking tables and subforms to be able to relate the questions and respective answers to a single quality review, but cannot figure out the linking/relationships to populate the active questions, respond to those questions, and at the end of the day, have the questions/responses linked to each individual quality review. Any suggestions on how to accomplish this objective?

Thanks!

[ranman256]

You'll have :
tQuestions tbl, (all questions ever)
QID
question

tPersons tbl:
PersonID
lastName
FirstName

tQGroup: (the group of questions)
Qgroup (Survey2016)
QID

tPersonQA tbl: (a persons questions and answers)
PersonID
QID
QGroup
Answer


Create a group of questions, like Survey2016, append all questions to it from the tQuestion table.
Then choose a person to add the Group of questions. An append query adds all the Group questions to the tPersonQA tbl.
the user then fills out the answers.

[geast]

Great guidance! I was able to create a flexible questionnaire based on ranman256's suggestions. Thank you.