Hi Dave, yes currently the subcategories relate back to the product (because the Previous project needed a certain process in that way).
Ok I need more of a work flow, because I'm getting so confused. How would the database structure look for categories and products. And how would the admin go about adding...because I was thinking the only way is assign a product on one of the 'add category' pages rather then selecting a category from a drop down on the 'add product' page. At least adding a product during the 'create a category' page would make it easier to add. Product to multi categories (if needed) but to be honestly maybe this feature isn't really needed. But how can I assign a sub category on the product page?