NewCMISGrad
MIS
- Oct 18, 2004
- 13
I have the following tables(shown Below):
tblQuestion
QuestionID AutoNumber
Question Text
tblAnswerChoice
AnswerChoiceID AutoNumber
AnswerChoice Text
The question table is filled in with 20 questions. The answer choice table is filled in with 6 possible answers. I would like to put 20 questions on a form and the 6 answers to be a group option choice. This should populate another table with persons name, ID, etc.. that also has a subdata sheet with the question & answer ID's. How can I accomplish this?
I also want to count each of the answers for each question in a report. Do I need to list the 20 questions out in the table fields instead of populating a table with the data?
Thanks,
NewCMISGrad
tblQuestion
QuestionID AutoNumber
Question Text
tblAnswerChoice
AnswerChoiceID AutoNumber
AnswerChoice Text
The question table is filled in with 20 questions. The answer choice table is filled in with 6 possible answers. I would like to put 20 questions on a form and the 6 answers to be a group option choice. This should populate another table with persons name, ID, etc.. that also has a subdata sheet with the question & answer ID's. How can I accomplish this?
I also want to count each of the answers for each question in a report. Do I need to list the 20 questions out in the table fields instead of populating a table with the data?
Thanks,
NewCMISGrad