Record updating

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a table with open order information. I want to evaluate and apply on
hand inventory (in another table) to each order line. If I have the inventory
I will apply the needed qty to order line and reduce on hand inventory by
same amount. I would do this line by line until I run out of inventory. I am
looking for a way to tackle this.
 
That's a fairly big question. It will be worth your while to buy a copy of
John Viescas' book, "Building Microsoft Access Applications" (Microsoft
Press, 2005).

The book contains the code you need to do exactly that, and a sample
database on CD that will save you many times the cost of the book.
 
Back
Top