[AccessD] Design question

Hi

 

I have a design question I'm looking for help with.

 

Scenario.....Applicant completing questionnaire.

 

Answer options vary...text reply, yes/no etc.

 

I'm not sure how to deal with questions when there are multiple replies 

e.g; tick which apply to you:

 

1.       Long hair

2.       Blue eyes

3.       Brown eyes

4.       Tall

5.       Short

6.       Old

7.       Young

 

The answer may contain one, more than one or all boxes ticked.

So options include having several fields in the answertable to store the
answers e.g. longhair y/n, blue eyes y/n and so on.

This may be okay for questions where there are 3,4,5 options but what if
8,9,10 or more.(what cut off point would you switch to storing in a
separate table?)

I assume I have to set up another table say tblMultipleOptionsAnswers

 

ApplicantID

MultipleOptionsQuestionID

AnswerID

 

So we can get values like 

1,1,1

1,1,4

1,2,1,

1,2,3

2,1,3

2,1,4

2,2,1 and so on.

 

Or is there a better way??

 

Thanks in advance

 

Richard

-----------------------------------------------------------------
Why not visit our website www.bury.gov.uk
-----------------------------------------------------------------
The information contained in this e-mail and any files transmitted
with it is for the intended recipient(s) alone. It may contain
confidential information that is exempt from the disclosure under
English law and may also be covered by legal,professional or other privilege.
If you are not the intended recipient, you must not copy, distribute or take any
action in reliance on it. 
If you have received this e-mail in error, please notify us immediately by using 
the reply facility on your e-mail system.
If this message is being transmitted over the Internet, be aware that it may be 
intercepted by third parties.
As a public body, the Council may be required to disclose this e-mail or any 
response to it under the Freedom of Information Act 2000 unless the information
in it is covered by one of the exemptions in the Act. By responding to this
e-mail you accept that your response may be subject of recording/monitoring to
ensure compliance with the Council's ICT Security Policy. 
Electronic service accepted only at legalservices at bury.gov.uk and on fax number 
0161 253 5119 .
*************************************************************