I have a problem concerning the construction of ma database structure. I have an online marketplace where my items are assigning to categories, then subcategories. For example, I am selling a brand of white chocolate, which is the subcategory "chocolate", which is in the category "sweet products". One product is assigned to only one category and one subcategory. Each subcategory is only assigned to their related category.
When I am creating a product, I would like to chose first the category "sweet product". Then, I would like when I have to chose the subcategory that only the subcategories assigned in "sweet category" appear.
Do you think it is possible ?
Thank you a lot !!