Calculate Product-Transaction

[moj6054]

Hi,

I design a database for product-transaction, My problem is:

I want when click in receive filed , then open transaction layout and enter qty of receive product. This maybe happend many times until receive product balance with qty purchace. In secodn time when go to layout transaction I want see my past record for this special (purchase and product according my design if it correct.)

Please see my sample database and help me for this.

Thank you.

Transaction.zip