Design help with multiple subforms

[cs_vision]

I have an excel spreadsheet that has been imported into access. This
spreadsheet contains client name, document name, document date and
classification. I have a list of questions that will be asked each client
based on their classification. Each classification contains a minimum of 4
questions with Yes or No for each question.

What needs to be done is once all the questions are received this
information will go into the database. The data entry form should have all
the fields mentioned along with the questions and answers each client gave.
What is the best way to design this database?

 

[Duane Hookom]

Consider reviewing the structure of At Your Survey found at
http://www.rogersaccesslibrary.com/OtherLibraries.asp#Hookom,Duane. This
might help with structuring your tables.