logic question on table/form layout

[GaryPanic]

ok guys
what I have is 5 (or more) options
lets say its fruit (Apple Pear Cherry Orange and Pineapple )
I have these in a table (its not fruit) and I have coded each with a reference
11,12,13,14, and 15

what I had in mind in another form/table is once 11-15 is selected (and only one per record) is that the questions that apply to that option are made available

I had in mind (rightly or wrongly) in the underlying table to get the questions that apply to the option

So Apple (could have up to 5 questions ) selected and Dlookup questions code11 in a questionsettable and put these questions in my main table (answers will always be yes or no ) depending on the answer it will do stuff (which will also be stored in my question set table )

I have kept this simple ( the questions below are examples - and the actual questions will not actually relate to each other (all apple questions could be Green Y/N or large enough and some could be straight statments that warrant an answer (ie have all the questions been answer - or are you happy with the apple ( the pear question may only have 1 question -but the max number of questions for any one selection is 5 questions)


Apple-
Q1 - Is it Green ? Y/N (yes -buy it) (no reject it)
Q2 - is it large enough ? Y/N (yes -buy it) (no reject it)
Q3 is it rotten ? (Y/N) (Yes reject it ) (no buy it)

 

[GaryPanic]

table lay out (I had in mind)

Iauto id on Question Set table
Questionfilter
QuestionNumber
QuestionName
QuestionText
QuestionAnswerYes(QAy)
QuestionAnswerNo (QAn)

Mzain table would be
xxx
Q1-(questionNumber)
Q1 Response (Yes/No)
Q1ResponseTxt (dependent upon above either QAy or QAn


Q2 .....

 

[gemma-the-husky]

I presume the right way to do it is to have

a) a colour table
b) a questions table
c) a colour-question table, linking the 2 together as many to many

then when you pick a colour, you can have a continuous subform showing the appropriate questions