I have used the Northwind Traders template to develop a database for a fruit tree nursery. Have fought through most of the problems I've encountered but can't find my way past this... If someone could show me how to solve it in the Northwind Traders db I would sure be grateful.
Can enter a new customer purchase and all goes well.... But if a customer wants to cancel or change an order before pickup, I can cancel, but allocated stock is not returned to inventory. I'm assuming VB code with record set wrapper is how I need to address this, and that several tables (products, orders, order details and inventory transactions) are involved, but I just can't think my way through this.
Anyone who could show me how to change the code (or add) to the Northwind Traders db so I could see the process would have my undying gratitude!
Thanks, in advance....