inventory table with a running total
Posted on 1999-11-04
I have 2 tables. One table is an inventory table and has two fields
"tblItem name" and "tblItem quantity". The other table which is called "tblInventory Out" is a record of all inventory items that are given out to users and has 7 fields which are "Description", "Quantity", "Date Out", "Date In", "Dept", "Signed Out By", "Signed In By" you probably don't need all these fields but they are there if you do.
What I need to do is when an entry is made in the Inventory Out form in the field name description say "Printer" and in the quantity field "4" I want to be able to automatically deduct 4 from the quantity field in the Inventory table and keep a running total of that item in the Inventory Out form. So when a user makes an entry, the information is read back to them immediately. Such as if there were 20 printers now there would be 16 listed. As an added attraction it would be nice if the user was notified if there were not enough of an item or the item requested is gettin low in stock.