Hey,
So I have three tables, Sales, Purchases & Inventory. I have 3 items A, B, C. In each sale, a customer can buy all three, just two or one of the items in whatever quantity they wish. On each day I make purchases of varying quantities of A, B & C...
Thank you for your response. To clarify. I would create a field called product ordered and link it to inventory. And then have another column for quantity? Would this limit my customers order to a single item? So if a customer places an order that in...
