logic question on table/form layout

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)

logic question on table/form layout