Search results
-
B
Northwind DB-Delete transactions and return stock when canceling order doesnt work
Ok so this the solution: Table Inventory Transaction is responsible for calculating amounts in your stock. That table is connected with table Orders through field Customer Order ID. So create delete query with following SQL code and name it something like qrdelete: Then change VBA code for... -
B
Northwind DB-Delete transactions and return stock when canceling order doesnt work
Actually it is very easy to be done with one delete query and simple VBA code. If you still need answer I will be more than happy to provide you with one.