Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
RobVG
Starting Member
42 Posts |
 Posted - 2003-07-03 : 17:40:27
|
| (Newbie)I'm working on a VB/SQL project that consists of three questionnaires. The last Form Has three questions with over a dozen check boxes each.It's been suggested that the values of each checked check box could be placed as a string In a single column. I'd rather not use multi values in one column.At this point I'm tempted to create a table for each question and a column for each checkbox that will contain a true/false value. Its important to be able to statistically group the answers.Maybe lumping the answers together would work if the table could be searched with an SELECT-WHERE-'LIKE'? |
|
|
mr_mist
Grunnio
1870 Posts |
Posted - 2003-07-04 : 02:40:36
|
| So what's your question? :)Personally, I'd try to keep the answers separately. I don't think each question needs its own table. That sounds wrong. All the questions can go in a "questions" table which is then joined to the "answers" table by way of a linking table for I imagine this may be many to many. You then have your users which also joins to the answers table to determine which, if any, boxes they have ticked.-------Moo. |
 |
|
|
RobVG
Starting Member
42 Posts |
Posted - 2003-07-09 : 23:22:12
|
Hey mr_mist,I did essentially what you suggested. It not only works, but it aslo makes sense. ThanksRob |
|
|
|
|
|
|
Basic table design question