By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
458,025 Members | 1,218 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 458,025 IT Pros & Developers. It's quick & easy.

Needed elp for a stock control database

P: 2

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
Mar 23 '07 #1
Share this Question
Share on Google+
1 Reply

Expert 2.5K+
P: 3,072
This is in general a "nasty" one as orders can be withdrawn.....

Personally I use the Stock and total the "delivered" Orderdetails to calculate the stock quantity on hand.
Once a year (or more frequent) I create a stocklist with the calculated qty and an empty column. The waehouse personnel can use the list when counting the real stock and enter the real number into the system. This will also allow a report on "stock leakage" :-)

Mar 24 '07 #2

Post your reply

Sign in to post your reply or Sign up for a free account.