Hi all,

I'm designing a dbase using SQL server and using VB.Net. i have a form (paper
form ) where the user is required to answer some questions and for some questions
he has to select more than one answer

e.g

What are your favorite colours?
1) checkbox1
2) checkbox2
3) checkbox3
4) checkbox4

Should i create a table only for that question and have my columns as checkbox1
to checkbox4 ? If that's the case if i have 50-100 questions similar to this
does it means i need to have 50-100 tables? i'm not really sure whether i'm
on the right path or if there are better solutions. Please let me know.

Thanks in advance for ur help..

Regards,
shobapond