SURVEY database - problem on "survey questions"

[mikarsen]

Hi, I have a survey database file containing the following tables

tblQuestions - contains survey questions
tblResponse - contains responses inputted by user
tblRespondents - contains info on user (e.g. Name, Add...etc)

Is it possible that answer to some questions are dependent on other questions?
for example:
Question 1 -True/false
Question 2 -True/false

Question 3 -True/false

If question1=false or question2=false then question3=false
(the response to question 3 is automatic and dependent on the responses of question1 and question2)

Thanks in advance for those who can give me some suggestions.

 

[KenHigg]

I'm thinking you can simply hard code this into the after update events for questions 1 and 2. ?

pseudo code:

If q1 = true or q2 = true then q3 = true

???

ken

 

[mikarsen]

Can u show me exactly how to do it?

btw, I've attached my sample database for reference.

My goals are:
1.) skip some questions depending on the answer to previous questions
2.) some questions rely on the answer of previous two (2) questions like what i said in my first post.

 

[KenHigg]

Hum... That's going to get messy pretty quick...

The only way I can see to do it would be to hard code it to the question which would zonk the whole dynamic questions model you have set up...

I'm sure you could do it but it would be extremely involved...

ken