Forum Discussion
Hannah16
Jun 12, 2020Copper Contributor
Help with order sheet
Hi, I’m hoping someone can help me. I’m trying to set up an order sheet on excel where I can keep a track of customer orders, names and addresses and then have a total number of items ordered at the b...
peteryac60
Jun 12, 2020Iron Contributor
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