By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
425,790 Members | 1,409 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 425,790 IT Pros & Developers. It's quick & easy.

Table design

P: n/a
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
Nov 13 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
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

Nov 13 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.