Question about normalizing a survey

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


--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...esign/200507/1

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?

--
Duane Hookom
MS Access MVP
--

"Lee Stafford via AccessMonster.com" wrote in
message ...
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


--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...esign/200507/1

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.


--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...esign/200507/1

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

--
Duane Hookom
MS Access MVP


"Lee Stafford via AccessMonster.com" wrote in
message ...
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.


--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...esign/200507/1