Calculation Item Sold

[moj6054]

Hi,

I have a problem with my database, I have some product, When I sold some of that,If a qty of product in Invoice less of Qty in hand then a new order automatic create.

I design my database and some script for that,

How I can attach it for review and send useful help?

Thank you.

[Maarten Witberg]

If you upgrade your membership then you will be able to attach and download demos and other files.

[moj6054]

My Database is: product, (PR_ID,PR_Name,Pr_Price,PR_Qty,cQtyInHand=Pr_Qty+Sum(OrderLine::Qty)-Sum(InvoiceLine::Qty))

Invoice (INV_ID,INV-Date,cTotalInv=Sum(cLineTotal))

InvoiceLine(INL_ID,INV_ID,PR_Name,Qty,Price,cLineTotal=Qty*Price)

Order(OR_ID,OR_Date,cTotalOrder=Sum(cLinetotal))

OrderLine(ORL_ID,OR_ID,PR_Name,Qty,Price,cLineTotal=Qty*Price)

How I can Design a formula ,When I sold some of my product,If a qty of product in Invoice less of Qty in hand then a new order automatic create.