On Tue, 19 Jan 2010 14:24:48 -0800, Tara Metzger wrote:
Hello,
I'm creating a survey database (Access 07). I have multiple tables and was wondering if you could help me with the design. Currently I have a tblQuestions & tblAnswers which contain only the questions themselves and all the possible answers, respectively. Would you recommend a 3rd table which ties all the responses from the tblQuestions & tblAnswers together? For some reason I'm stumped by this and I'm sure it's a very easy solution.
Thank you!
You need at least a couple more tables: let's call them tblSurvey (one record
for each time a survey is filled out) and tblResponses (related one to many to
tblSurvey, who took the survey and when, and to tblQuestions, which question
is being answered).
For a fully worked out example see
Duane Hookum's "At Your Survey":
http://www.rogersaccesslibrary.com/Otherdownload.asp?SampleName='At%20Your%20Survey%2 02000'
or
Roger Carlson's Training Registration database:
http://www.rogersaccesslibrary.com/d...gistration.mdb
--
John W. Vinson [MVP]