Table design

[Grant]

Hi I have a survey to build on access 97 with 21 questons all of which
have a intial form being displayed with a yes/ no response option,
then depending on the answer go to another form to give more
information , ask another 5 / 6 fields worth of information both memo
& number some compulsory some not.

My intial thoughts was a questions table with an answer table, answer
table linked by survey question number so each question would have
correspnding detail in the answer table with various fields filled in
& some not. The problem is that the answer table will have loads of
fields that are empty as some answers don't pertain to specific
questions. Do I have to have a table for each seperate question or is
the above the best solution ?

Please point me in the right direction

Thanks

Grant

[clintonG]

There are over 200+ models to study at DataBase Answers [1]
--
<%= Clinton Gallagher, "Twice the Results -- Half the Cost"
Architectural & e-Business Consulting -- Software Development
NET cs*********@REMOVETHISTEXTmetromilwaukee.com
URL http://www.metromilwaukee.com/clintongallagher/

[1] http://www.databaseanswers.com/

"Grant" <gr***********@uk.abnamro.com> wrote in message
news:a5**************************@posting.google.c om...

Hi I have a survey to build on access 97 with 21 questons all of which
have a intial form being displayed with a yes/ no response option,
then depending on the answer go to another form to give more
information , ask another 5 / 6 fields worth of information both memo
& number some compulsory some not.

My intial thoughts was a questions table with an answer table, answer
table linked by survey question number so each question would have
correspnding detail in the answer table with various fields filled in
& some not. The problem is that the answer table will have loads of
fields that are empty as some answers don't pertain to specific
questions. Do I have to have a table for each seperate question or is
the above the best solution ?

Please point me in the right direction

Thanks

Grant