Inventory table

S

sazd1

Joined
Jul 26, 2009
Messages
1
Reaction score
0
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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Inventory control / on hand count 1
removing & adding stock to inventory database 1
Stock Control Database 1
how to create an archive table to store ordering info 3
Changing a Field in one table according to the other 3
Updating a table from a subform 2
Update Records In A Table 1
Table design for Inventory Management 1

Top