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

Needed help in a stock control Database.

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


bartonc
Expert 5K+
P: 6,596
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
Hello and welcome to TheScripts. I'm glad to see that you have found your way around the site. The experts on the Access Forum are truly awesome. Have fun and good luck.
Mar 23 '07 #2

Post your reply

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