I have a Products table. Each product has a category_id and
subcategory_id which relate to the categories and subcategories tables
How do I create a view for creating new subcategories? Obviously,
upon entering a new subcategory, I would need to select the category
to which it should belong.
Same problem with entering new products. I have to choose a
category from a drop-down list and then a subcategory that relates to
Any help greatly appreciated.