Stock management problems

[NumLock]

Hello,

I'm new to Access and I need to make a stock management system.
But I got some problems with adding products to different departments.

I need to add products to different departments. So I can see which department uses the most paper for example. But I don't know how.

I used update query's but I cant get it working.

I need to select products and a amount at the Mutation_deparment table and add them to a department. But the stock indication needs to be update to.

So if I add 2 boxes paper to deparment Administration. The stock indication at the product table needs to be update to.


Tables
Keys


Products
Product ID
Name
Distrciption
Stock indication

Mutations_Department
Mutation ID
Date
Deparment name
Product ID
Amount

Deparments
Deparment name
Deparment chef
Telephone number



Relations

Tables: Products ............ Mutations_Departments....... Deparments
Keys: Product ID ---------- Mutation ID ---------------Deparment name

ps: sorry for the bad english, im from the Netherlands.

 

[jdraw]

Here's a link that may be helpful. Conceptual data model for retail store inventory management.

http://www.databaseanswers.org/data_models/inventory_control_for_retail/index.htm

 

[georgedwilkinson]

You'll find it much easier in Access to avoid table and column names with spaces and/or special characters (except underscore).