How to create order list


#1

I’m trying to make a simple base with a list of customers, a list of orders and a list of items. It is a simple purchase order organizer.
Items must have a price. Each customer can have many orders. Each order is unique. Orders have items amount, price and total price.
It is not so complex but my trying to build it does not give me the results i want, my count of items is not order unique meaning it will go to the item-list and this will result in changes of items amount in other orders.
I can not find any template that does this right.
Can anybody help with this? or point me to a template…

T.i.a.