Question about normalizing a survey

[Lee Stafford via AccessMonster.com]

I have checked out Duane Hookem's AYS DB and it has given me a great start,
but I am getting in trouble trying to match up the answers with the correct
questions and recording them with one unique survey number. I am not sure
what info to give in order to get help. It is a rather simple survey with 4
sections, three sections have yes/no answers and the last section has four
possible answers. They all have points associated with them. Here are the
tables that I have:

tblQuestions tblResponses tblSection
tblWOInfo

*QuesID *QuesID
*SectionID *WONumber
SectionID *SectionID
SectionDesc TechID
QuesNum *WONumber
SectionID
Question Response
Points

Does this sound about right? It doesn't work yet. I have the DB working,
but everything is in the tblWOInfo and Duane made me realize it wasn't
normalized. Can someone steer me in the right direction?

tia,
Lee

 

[Duane Hookom]

You posting has suffered greatly from word wrap. Can you post your table
structure in a more normalized manner with one table (and fields) list under
the other?

The questions table allows you to set levels. Won't this suffice for your
sections?

 

[Lee Stafford via AccessMonster.com]

tblQuestions
*QuesID
SectionID
QuesNum
Question
Points

tblResponses
*SectionID
*QuesID
*WONumber
Response

tblSection
*SectionID
SectionDesc

tblWOInfo
*WONumber
SectionID
TechID

The levels probably would work, but I do not understand the whole setup. I
sort of related the Sections to the Surveys. I only need to display the
sections that are being answered. There will only be two sections answered
at any given time. 1 and 4 or 2 and 4 or 3 and 4.

Thanks for your help Duane.

 

[Duane Hookom]

You shouldn't need SectionID in tblResponses since tblQuestions has
SectionID.