Question about normalizing a survey

  • Thread starter Thread starter Lee Stafford via AccessMonster.com
  • Start date Start date
L

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
 
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?
 
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.
 
Back
Top