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!