but in my case, there are sizes as well. So each fabric bag will be either small, medium or large and the components (zipper, strap etc) will also have the same size options. A small fabric bag will have small zippers and small straps. What kind of database structure should I have and how should those coordinate with each other?
Hi Ayush, the database structure of the solution you linked seems perfect, may I know what issues you faced when attempting to implement it?
Each differing product size would have their own record in the Products table, and each differing product component would have their own record in the Components table, allowing you to create the product compositions as needed, right?
As much as I can understand, a Small bag will be a different product from the large bag and will use small components and large components respectively. I want to be able to just link once what components Bag 1 will use rather than linking it twice, separately for large Bag 1 and small Bag 1 as the components used will be same but different size. Is it possible to use single select for size?