Checkboxes & lots of them

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

JP SIngh - 09 Aug 2005 15:32 GMT

I am creating a database which will be used as a backend to an internal
website.

One of the table will hold data that our customers will fill in. This is
more like a questionarrie and about 6-7 questions are multiple choice i.e.
checkboxes.

Does anyone have any suggestions as to how to store those responses can be
stored in the database? For example one of the questions have about 16
responses? Shall I create a seperate table for each of the multiple choice
questions?

thanks

Reply to this Message

Allen Browne - 09 Aug 2005 15:58 GMT

Download the sample database by Duane Hookom from:
http://www.rogersaccesslibrary.com/Otherdownload.asp?SampleName='At%20Your%20Sur
vey%202000'

It demonstrates the kind of structure you need to handle survey type data.

Signature

Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

>I am creating a database which will be used as a backend to an internal
> website.
[quoted text clipped - 7 lines]
> responses? Shall I create a seperate table for each of the multiple choice
> questions?

Reply to this Message