I am working on an application for Point of Sale system. I am using Vb Express 2008 with MsAccess as database. I am almost at the final stages and now i am stuck up with the stock position system.
Like I have SaleTransaction table and also a PurchaseTransaction table.
I want to design a table with the following fields:
ItemId,StockDate,ItemName,QuantityPurchased,QuantitySold,BalanceStockinHand.
How i can make this table only using MsAccess. Please guide me on this issue as this is almost the final part of my application and to generate stock position is a very important part of this system.
Thanks.
Like I have SaleTransaction table and also a PurchaseTransaction table.
I want to design a table with the following fields:
ItemId,StockDate,ItemName,QuantityPurchased,QuantitySold,BalanceStockinHand.
How i can make this table only using MsAccess. Please guide me on this issue as this is almost the final part of my application and to generate stock position is a very important part of this system.
Thanks.
