Wonder if I'm on right track!
What relations are missing if I in order, pic the various product i use and in the same time the count for that product is deducted from the product count (or a stock table or some kind of inventory)?
i have order, orderlineitem, product, purchase, suppliers, customers and contacts table.
I'm not sure all the relations are necessary.
When I buy products, I stand in purchase and want to buy different product from one supplier. And of course the count should increase in the product table.
I'm using portals in order, purchase and product table.