Hi I’ve created a databases with 3 tables customer, products, orders.
I want to insert 1 order that can have mulitple products. So for example a customer may want to order coats, sunglasses and shoes in one order. At the moment I’m only allowing one product for an order.
How can I do this but show in orders table that the products are part of the same order. Not just seperate orders. So you can see actually see that a customer purchased multiple products in one order?