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?
![[ponder] [ponder] [ponder]](/data/assets/smilies/ponder.gif)
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?
![[ponder] [ponder] [ponder]](/data/assets/smilies/ponder.gif)
Thanks,
NewCMISGrad