Record updating

[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.

 

[Allen Browne]

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.