Posted by mail2riyadh@gmail.com on 05/17/06 07:50

Hi Tia

As you are saying, associated characteristics of a item should be eight
all time. I think this is not a good idea. My experience says that
after few days you will want add more characteristics for an item. So
it would be better making another two table along with Item table

1. Create table with list of characteristics
CharacterID
Associated characteristics
2. Create table to make many to many releationship with Item table and
Characteristics table
ItemID
CharacterID

By the by, this is my personal preference.

Thanks
Riyadh Hossain

[Back to original message]