troubleshooting Question

Purchase Order Price with the Microsoft Northwind Database

Avatar of Sean Holloway
Sean Holloway asked on
Microsoft Access
22 Comments2 Solutions383 ViewsLast Modified:
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”
crystal (strive4peace) - Microsoft MVP, AccessRemote Training and Programming

Our community of experts have been thoroughly vetted for their expertise and industry experience.

Top Expert 2015

The Distinguished Expert awards are presented to the top veteran and rookie experts to earn the most points in the top 50 topics.

Join our community to see this answer!
Unlock 2 Answers and 22 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 2 Answers and 22 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros