sub category section
Have got a new site where I have a main categories (covered by productcategories in the db) which can then have sub categories within each main cat - I need to set it up so that the client is able to add/remove sub cats and link to the parent main category.
I then need to set it so that the client is able to select the main/sub category for each product
My current tables set up in the db are products, productcategories and productmanufacturers so guess I need to add productsubcategories and structure the columns for the new one with similar columns to productcategories...
Just not sure, that being the case, how I then go about linking the new one and the relaional aspects
Any suggestions please mate?