Incorrect Answers/Remediations Added to Report

[NascarBaritone]

Before I dove to deeply into the design I figured I would ask for some opinions. I currently have a database that is acting as an audit questionnaire. Lots of drop downs with mostly "Yes" or "No" options from "Do you understand that..." being the question.

At the end of the audit I want the form to generate an exit report that shows all of the remediations (i.e., person answered "No," but the answer should have been "Yes").

I know this is very broad, but any suggestions on what the best method to go about capturing the right and wrong answers and then generating these into a report would be?

I'm open to any ideas.

 

[Access_guy49]

Is it like an Answer key??? or could it vary depending on the subject??

If person 1 answers question 1 yes... and they should have answered no..
If person 2 answers question 1 yes... could that be correct??? or will it always be no?

 

[NascarBaritone]

Yes, it will be like an answer key. The right and wrong answer will be the same for everyone that answers the questions.

 

[Access_guy49]

Then I would simply have a table of answers.. with question ID, Person ID and Answer...
Then an answer key table with a question ID that links to the question ID in the answer table.. and the correct answer.

When you query out all the answers for person ID 1 (lets just say)
Then you can link to your answer key.. from there you can have a report display the answer they have given.. (From the answer field) and the related correct answer from the answer key table.