Okay...here we go.
I am new with all extensions, so I got some questions, especially with Data Assist.
I have a customer who wants a online store, so I am using all the extensions to make a website for him. He has about 400-500 products to sell. There are five (5) categories of the types of products. In each of those categories, it is further broken down into more categories (range of five (5) to fifteen (15) types), depending on the product. The free database table doesn't seem to cut it (using it due to lack of mysql experience). I want to use the product table for sure (with some changes). The product category table would work for the five (5) main categories. I assume I need to make another table for the sub-categories. If so, do I need to make a column (or row) in the product table to show the sub-categories table with a link to it.
Any help would be greatly appreciated. Thanks.