AnsweredAssumed Answered

Inventory or stock relations problem

Question asked by andresen on Mar 21, 2017
Latest reply on Mar 23, 2017 by fivos@macclub.org

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.

 

order---<orderlineitem>---product

product---<purchase

and

product---<orderlineitem

 

purchase---<product

and

purchase---<orderlineitem

and

purchase>--suppliers

 

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.

Outcomes