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?