troubleshooting Question

Access 2010 ... keeping track of inventory across different tables

Avatar of peispud
peispudFlag for Canada asked on
Microsoft Access
7 Comments2 Solutions534 ViewsLast Modified:

I am using access 2010

I have three tables for an inventory list.  Each table has two important fields.  

Stock #  and quantity...............  Stock # is the key in each table and they are relationally linked.

Table 1 = input to inventory
Table 2  =  Withdrawal from inventory
Table 3 = Withdrawal  from inventory

I want a query or a table so that I have available to me at any time the current inventory.

What is the correct way to approach this?
Join our community to see this answer!
Unlock 2 Answers and 7 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 7 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