I’m building a table to track sales and inventory. Each product has a number of components, and sales/resupplies impact the total inventory of components.
chair 1 = 1 wood structure + 1 leather canvas
chair 2 = 1 wood structure + 1 velvet canvas
So a product can have multiple components, and a single component can be found in different products. I think this qualifies as a many to many relationship, as explained by the airtable guide.
I built a quick prototype, and managed to do so without using a junction table, and it seems to work just fine. Why is that? By bypassing the junction table, am i missing something that might become a problem down the road?