making a form with checkboxes for answer to questions

[kfoyil]

Im trying to make a form that contains several (14) questions with checkboxs for a possible 5 or six answers.

I had it working somewhat with subforms but really did not like the way it worked ...i think i may have needed a continuous form view for the question subform ... im still working on it .. if you can help i would be thankful

[ScottG]

I think I can help you with this but I have a few questions first.

1.) Are the 14 questions always the same?
2.) Are the 5-6 answers always the same?
3.) Where are the answers stored? In a different table?

Thanks,
ScottG

[kfoyil]

Yes the Questions are different
The 6 answers are always the same

The one to many on the Questions and answers i got to working
I originallly had 3 tables one for the main info like date Time and person doing the checklist

i had a table with the questions and a table with the answers but just couldnt get the relationships working like i need


Ive got it working for now but my table is too large .....i dont like it

thanks in advance for any help..

Ken