Purchase Order Price with the Microsoft Northwind Database
Posted on 2016-09-14
Maybe I am missing something here, but when I create a new purchase order in the Northwind database, and select a product the unit price is generated from the products table and does not update back to the products table if it is different?
When a vendor has an increase, I’d like to track how much the increase was from the previous is for reporting purposes.
Are there suggestions do you have to track historical data?
You can get a copy of the database by going to Access > New and searching for “Product Inventory”