Survey with many answers taking many actions

[Jake F]

I'm trying to creat a survey database that based on the responses to yes/no
questions will link the candidate to required training or equipment. The
problem I am running into is some training courses are required based on
multiple questions, some questions have multiple training courses for them as
well and the same is true for the equipment side. I haven't been able to
find a one to one or one to many setup so far and am wondering what other
options there are.

 

[mscertified]

You need to analyse your data requirements and come up with a normalized
table design. There is no shortcut to doing this. Only you know the data
requirements. You should be able to model any situation using multiple tables.
For instance to define what courses are required based on multiple answers,
would require something like:
CourseID
QuestionID
ResponseID
where if all the questions and responses match, the course is required.


-Dorian

 

[John W. Vinson]

I'm trying to creat a survey database that based on the responses to yes/no
questions will link the candidate to required training or equipment. The
problem I am running into is some training courses are required based on
multiple questions, some questions have multiple training courses for them as
well and the same is true for the equipment side. I haven't been able to
find a one to one or one to many setup so far and am wondering what other
options there are.

One good one is

http://www.rogersaccesslibrary.com/Otherdownload.asp?SampleName='At Your Survey 2000'

Your query may be a bit complicated but the entire application will be much
simpler with a properly normalized design rather than one field per question,
as I'm guessing you are now doing.