Hi,

I have a database of Questionnaires with multiple choices.
Tables can be summarized as follows:
(1) QstnID, QstnNo, QstnTxt,UserAns
(2) ChoiceID, QstnID, A, B, C, D
QstnID is the PK of one table so I dont have problem on interconnecting these two tables.
I already have a form by which the questions are displayed as one record and the choices such as A, B, C, D are displayed as well. This will work like an examination database. The field UserAns on Table 1 stores the value of the Correspondent answer. Now, what I want to do is to verify the UserAns with another table that stores the right answers and finally gives the total number of the correct answers of the user/correspondent has done.