Technical Support Forums

Free, outstanding support from WebAssist and your colleagues

› WebAssist Forums › Archive › eCommerce mySQL Database › additional product category

View all replies to this thread

additional product category

Thread began 1/27/2011 7:03 pm by turk361661 | Last modified 1/31/2011 7:15 am by turk361661 | 2802 views | 4 replies

1/27/2011 7:03 pmturk361661

additional product category

I have product that has the following parameters:
It must belong to 1 of 5 categories either ABCD or E.
It may also belong to a sub category of F or G or none.

I'm using DataAssist Wizard to create the Admin pages. When the user clicks on Insert product page I want them to be able to Insert a new product, select a category (ABCD or E) and then select a subcategory (F or G or none).

Should I create an additional table in the ecommerce database similar to "productcategories" and call it productSUBcategories?
Or would the "productoptions" table be better at handling this structure/releationship.
Can you please advise or offer any insight? If you have any tutorials/examples using the ecommerce database that might be helpful too.

Thanks,
Danielle

Build websites with a little help from your friends

Your friends over here at WebAssist! These Dreamweaver extensions will assist you in building unlimited, custom websites.

Build websites from already-built web applications

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.