Hello experts,
I hope you are all well.
I'm currently working on Northwind sample database in Access 2013. I'm trying to learn as much as I can from this db and
also trying to make it work so my friend can use it for small business.
Everything works fine so far, but I stucked with one problem. Delete transactions and return stock when canceling order does not work and
as a result of this I will get incorrect stock numbers.
Problem description:
When I do new Customer Order, I pick one or more items from the list which are not in stock. This will show prompt telling
me if I want to create Purchase Order. That's fine, so I will create Purchase Order for selected products and will add them to my
inventory to fill items on back order. Up to this point everything works fine. However, when I decide to delete (cancel) this order,
database won't delete all data from Inventory Transaction table, all those back ordered items (which suppose to be deleted) are still
there. As a result of this I get incorrect numbers in my inventory which is populating into the rest of database, because these items
won't delete.
Note: Delete Order button will delete only items which have OrderID in the record in Inventory Transactions table.
Unfortunatelly
filled items form back order does not have OrderID in there. I hope there is some slution for this.
Can I ask you for some help or recommendation to overcome this issue please.
I will try to attach my version of Northwind db here fro you to make better picture of this issue.
Thank you very much fro any help.
Martin
I hope you are all well.
I'm currently working on Northwind sample database in Access 2013. I'm trying to learn as much as I can from this db and
also trying to make it work so my friend can use it for small business.
Everything works fine so far, but I stucked with one problem. Delete transactions and return stock when canceling order does not work and
as a result of this I will get incorrect stock numbers.
Problem description:
When I do new Customer Order, I pick one or more items from the list which are not in stock. This will show prompt telling
me if I want to create Purchase Order. That's fine, so I will create Purchase Order for selected products and will add them to my
inventory to fill items on back order. Up to this point everything works fine. However, when I decide to delete (cancel) this order,
database won't delete all data from Inventory Transaction table, all those back ordered items (which suppose to be deleted) are still
there. As a result of this I get incorrect numbers in my inventory which is populating into the rest of database, because these items
won't delete.
Note: Delete Order button will delete only items which have OrderID in the record in Inventory Transactions table.
Unfortunatelly
filled items form back order does not have OrderID in there. I hope there is some slution for this.
Can I ask you for some help or recommendation to overcome this issue please.
I will try to attach my version of Northwind db here fro you to make better picture of this issue.
Thank you very much fro any help.
Martin