https://www.webmaster-forums.net/crss/node/1018211 en https://www.webmaster-forums.net/web-database-development/table-structure-shopping-cart#comment-1106876 <p>I think you are trying to make one element (category) do too many things.</p> <p>An item has many aspects to it. Category, Color, Size, Weight (for shipping), partners (when you sell a printer suggest a printer cable to customer), yada yada. Just add more field,s and clean up your category concept. You can always do multilevel reporting (summary or detail) later based on multiple columns in a query.</p> <p>I hope this helps.</p> Mon, 15 Apr 2002 04:01:25 +0000 galt comment 1106876 at https://www.webmaster-forums.net https://www.webmaster-forums.net/web-database-development/table-structure-shopping-cart#comment-1106629 <p>A setup like this should work or at least point you in the right direction:</p> <p>Cars<br /> ----<br /> CarID<br /> CarTypeID (link to CarTypeID in CarType)<br /> ColorID (link to ColorID in Color)<br /> AccessoryID (link to AccessoryID in Accessory)</p> <p>CarType (2 door, 4 door etc)<br /> -------<br /> CarTypeID<br /> CarType</p> <p>Color (blue, red etc)<br /> -----<br /> ColorID<br /> Color</p> <p>Accessory (stereo model)<br /> ---------<br /> AccessoryID<br /> Accessory</p> Wed, 10 Apr 2002 21:09:40 +0000 Peter J. Boettcher comment 1106629 at https://www.webmaster-forums.net