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

yes, you would want to create a new sub categories table to associate the product to subcategories.

Hi Jason,

Thanks for the advice. I created my additional subcategory table.

Out of pure curiosity can you explain or give me an example of when the "productoptions" table would be useful.

Thanks again for the advice.

If you can point me to a tutorial which discusses using the productoption table, that would also be great. I see a couple on the forums mention the tutorial but I could not find the link.

Thanks again for the help,
Danielle

On the eCart support page is the link to the product options tutorial:
product_options.php