one category for each product
- store selected category ID in products table
versus products belonging to multiple categories
- use a productcategories linking table, this is similar to the genres example in the Manage relational table tutorial.
Your friends over here at WebAssist! These Dreamweaver extensions will assist you in building unlimited, custom websites.
These out-of-the-box solutions provide you proven, tested applications that can be up and running now. Build a store, a gallery, or a web-based email solution.