Multiple choice questions

[lsmcal1984]

All,

I am using Microsoft Access 2003 (due to workplace practices!) and I need to allow each contact to answer multiple questions. For example:

Contact 1: Answered question 1, 2 and 3
Contact 2: Answered question 2
Contact 3: Answered question 1 and 3

Ultimately, I need to store this information and create a form that allows each contact record to select the questions answered.

I know it's probably very simple, but I can't see the wood for the trees.

Any help appreciated (file attached)

 

[Pat Hartman]

If you have more than one of something, you have "many". When you have "many", you need a new table. So the questions/answers for each contact will be stored as rows in the questions table. Contact 1 will have 3 rows. Contact 2 will have 1 row and Contact 3 will have 2 rows. Use a subform to display the question data.

 

[lsmcal1984]

Thanks for your reply, I have created the relationships as described. Now I’m going to move onto subforms and post in the relevant category. Thanks for your help.