M
mary
I am new to access and I really need some help. I have two tables, order
table and supply table. Each table has an order form and a supply form
respectively. This database is use to collect supply items and the order form
is to record who collects the items from supply. Everything runs fine expect
that when an item is removed from the order table it does not auto subtract
from the quantity field of the supply table. The supply table has
InventoryID, CategoryName and Quantity. Whereas, the Order table has
InventoryID, CategoryName and Quantity Out. I will like to have an update
query that will auto subtract quantity out from quantity. Thanks in advance.
table and supply table. Each table has an order form and a supply form
respectively. This database is use to collect supply items and the order form
is to record who collects the items from supply. Everything runs fine expect
that when an item is removed from the order table it does not auto subtract
from the quantity field of the supply table. The supply table has
InventoryID, CategoryName and Quantity. Whereas, the Order table has
InventoryID, CategoryName and Quantity Out. I will like to have an update
query that will auto subtract quantity out from quantity. Thanks in advance.