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 |
batott
Starting Member
7 Posts |
Posted - 2008-02-04 : 12:24:45
|
I was just wondering what would be a preferred approach in designing the tables against checkboxlist?For example I have 3 checkboxlist: chklVendor chklModel chklColorand each will have lets say 4 - 5 list items.Here are the different types of approaches that I've seen when designing database tables: 1. Creating tables for each checkboxlist. 2. Creating a single table and storing the values in a comma delimited format. 3. Using XMLAlso these attributes will be used in the search form as one of the fields. |
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-02-04 : 22:37:42
|
Should design db based on business process instead of checkboxlist. |
 |
|
|
|
|