help needed on a stock control database (1 Viewer)

[adamwhite567]

Hi

I am quite new to access and i can grasp things quite easily.

Basically i am make a stock control data base for a food company. I am making it so theres an order table and a stock table. Basically i want to know how to change the Quantity avalible in the stock table fom the orders table.

I dont know if i have explained that very well. But basically i have related the product name in the stock table to the product name in the order table. So i can add a number so that that the quantity of the product will change on the stock table.

If there are any easier ways of doing this rather than having 2 tables it would be useful

Ive tried all types of things and i cant get it to work. Any help would be very much appriceated.

Thank You

 

[RuralGuy]

Not a simple subject. Inventory Control: Quantity on Hand

 

[The_Doc_Man]

Search this forum for topics such as Inventory, Stock Levels, On Hand

This topic has been beaten to death several times.