I am working on an application for Point of Sale system in VbExpress 2008 with MsAccess as database and now i am on the final part of this application which is maintenance of Stock.
I have two tables related to stock.
PurchaseTable: PId,PDate,InventoryId,ItemName,QuantityPurchased,Price,Amount
and SalesTable SId,SDate,InventoryId,ItemName,QuantitySold,Price,Amount
I have to create a table as InventoryRecord:
InventoryId,TransactionDate,ItemName,QuantityPurchased,TotalAvailableQuantity,QuantitySold,BalanceQuantityAvailable
How I can maintain InventoryRecord table to get data from the two tables PurchaseTable and SalesTable and to update the quantity record.
Please advise.
I have two tables related to stock.
PurchaseTable: PId,PDate,InventoryId,ItemName,QuantityPurchased,Price,Amount
and SalesTable SId,SDate,InventoryId,ItemName,QuantitySold,Price,Amount
I have to create a table as InventoryRecord:
InventoryId,TransactionDate,ItemName,QuantityPurchased,TotalAvailableQuantity,QuantitySold,BalanceQuantityAvailable
How I can maintain InventoryRecord table to get data from the two tables PurchaseTable and SalesTable and to update the quantity record.
Please advise.