• Status: Solved
  • Priority: Low
  • Security: Public
  • Views: 28
  • Last Modified:

Access Northwind Database. What happens when goods on a purchase order are received?


In the Access Northwind database I am trying to work out how goods received are tied to a purchase order.
I can see that the "Inventory Transactions" table has a "Purchase Order ID" field.

Murray Brown
Murray Brown
1 Solution
John TsioumprisSoftware & Systems EngineerCommented:
The Purchases Subform for Purchase Order Details is linked to the Purchase Order details via Purchase Order ID (Master-Chield Fields)...so when you enter goods...they are related to the exact PurchaseID
Murray BrownMicrosoft Cloud Azure/Excel Solution DeveloperAuthor Commented:
Thanks very much
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Cloud Class® Course: Certified Penetration Testing

This CPTE Certified Penetration Testing Engineer course covers everything you need to know about becoming a Certified Penetration Testing Engineer. Career Path: Professional roles include Ethical Hackers, Security Consultants, System Administrators, and Chief Security Officers.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now