I am designing an Access DB to collect responses to Questions in a contest entry form.
Content Entrant Name, Address, etc...
QUESTION ----- RESPONSE
Question 1 ----- A or B or C
Question 2 ----- A or B
Question 3 ----- A &/or B &/or C &/or D
Question 4 ----- A or B or C or Other_________
Some questions will allow the entrant to select more than one response
as in Question 3
Some Questions will require the entrant to write in a response as in Question 4
I currently have 3 Tables
ENTRANT QUESTIONS RESPONSE
But I can't get my form to work.
This seems like a simple design but is in fact rather perplexing.
Can someone offer some advice.