Re: Survey Design

Tech-Archive recommends: Fix windows errors by optimizing your registry

Hi Ami - I just got home and went straight to the computer to input
your table design. Your layout feels elegant compared to my boxed in
thinking. I guess i have had my nose too close to the grindstone for
too long.

Hopefully you can bear with me for a fe more questions on your design:



So, you'd have this:

tblQuestion
QuestionID
QuestionText

tblPossibleAnswer
AnswerID
AnswerText

tblClients
ClientID
(Other stuff)

tblAnswerSession
AnswerSessionID
ClientID
AnswerDate

tblAnswers
AnswerSessionID
QuestionID
AnswerID

Are the following the correct Primary keys?

tblQuestion = Question ID (number/no dupes)
tblPossibleAnswers = AnswerID (number/no dupes)
tblClients = ClientID (autonumber/no dupes)
tblAnswerSession = AnswerSessionID (autonumber/no dupes)
tblAnswers = ??? not sure

What are the relationships?
The only one I think I see correctly is tblClients onetomany
tblAnswersessions. But maybe I am wrong - I just wanted to proof to
you that I am trying to work this out myself as much as possible.
Again I have not have enough time, yet, to ponder the proper
relationships and I would appreciate your wonderful help on this :)


Third - I am not sure what to do with referrential integrety, enforce
update and delettions and join type. I guess I just don't understand
this part well enough, yet to know what settings matter and which way
they should be set.


You need to have a continuous form that pulls from a Left Join of
tblQuestions and a join of tblAnswerSessions and tblAnswers.

I sense that this is a complete answer for somebody who knows what
they are doing. Left join means answer number 2 on the "type of Join
dialog", no? Is a 'join" number 1?

If possible, could you tell me in more layman's terms such as here are
the relationships and the corresponding joins.

Could I then use the form wizard to make a form which has tblClient,
tblQuestions, tblAnswerSessions and tblAnswers? Pretty it up
afterwards? Or is the wizzard too limited?

Fifth - I need to have a calculated total based on the answers and
track each clients pro/regress over the time they have participated in
the survey.

You can do that with a query or a report.

Once I get the tables and form done I think i'd be OK figuring out the
correct queries/reports. In other words I am hopeful that I would not
have to take up any more of your time. I already feel guilty enough :(

HTH;

Your help is not only technical it's also giving me totally new hope
and enthusiasm for this project. I have already learned a lot on my
own by trying to get this done but you have really opened my eyes on
how to think about this project. I am sorry if this sounds gushy but
your help has made me realize how bummed out and frustrated I had
become. I really want to learn how to do databases well, thanks a lot
for your time and help!

Amy

.