Return to Inventory and Delete Transactions

M

mcdowdjr

I have a table order, with information, then as transactions of the
order, there are records in a transaction table. In using a macro, and
some SQL coding, how do I delete the order, but I have to have the
following: 1) the inventory returned to table inventory from the
transaction table for the multiple transaction records. Confusing
maybe, but I have already coded and have gotten the first listed,
transaction record to be returned to stock, and then deleted, however,
I cannot get the second transaction for the same order to be returned.
-Thanks for any help.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Adding a Returns Module to Northwind 2007 0
How do I figure out amout due from transaction file 3
VBA Pivot Table Error 1
Inventory Transaction Problem 1
Transaction problem between DAO and ADO 6
Inventory transaction table - set up 4
Filtered Records as source for appending records to a table 1
Allen Browne's audit table 1

Top