Jun 12 2020 07:42 AM - edited Jun 12 2020 07:44 AM
Jun 12 2020 11:26 AM
Hannah,
It is not good design practice to combine customer details and orders into one table - it is better to have a customer table and an orders table. I have done a simple design to show a customer table and an orders table. Associated with the order table are two 'pivot tables' - the pivot tables allow you to present the data in may different ways. I have shown one by customer and one by order. These are just examples but there are many different options.
I hope this helps!
Peter