D
DistrautMan
ok how do i use an append query or update query to update the "in stock" in
my table from a different table where the value has been altered from the
original because of the quantity value entered on the subform of the invoice?
basically you enter a quantity into the subform and it subtracts it
automatically from the original in stock and i want it to replace the old in
stock with the newer one.
thanks in advance for those who help
my table from a different table where the value has been altered from the
original because of the quantity value entered on the subform of the invoice?
basically you enter a quantity into the subform and it subtracts it
automatically from the original in stock and i want it to replace the old in
stock with the newer one.
thanks in advance for those who help