Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

populate table with choices or defining table fields for choices

Status
Not open for further replies.
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]
Thanks,
NewCMISGrad
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top