Hi,
I have made a shopping cart and I need some help in setting up tables to store order details.
Each customer can have multiple orders. Each order has multiple items. I have a table that stores customer information, with a customer id. How can I set up the orders tables since each order can have an undetermined number of items in it.
I want to be able to retrieve the orders a particular customer has put, along with items in each order.
TIA.