Dealing with Inventory data

[Mishanya]

I have tblTransactions wich stores details such as:

TransactionID
ProductID
ProductQty
TransactionPrice
TransactionDate
TransactionType (combo In/Out)

In order to view products in stock I need to build a form with a field that
sums In's as "+" and Out's as "-".
In most Inventory Templates I've found the In's an Out's are stored in
different fields and even different tables (e.g. tblPurchase and tblSales).
Is there an elegant way to use combo for choosing TransactionType (without
making the user enter ProductQty for Out's with "-") and then to calculate
the stock?

 

[Mishanya]

Please consider this as answered - I've found the answers in this post:

http://www.microsoft.com/office/com...&p=1&tid=7610a4cc-570f-40f8-b9b3-fd3c1f8484e8