Update Product quantity with Update Query Please Help

Deonh911

Registered User.
Local time
Today, 05:50
Joined
Mar 5, 2013
Messages
30
Hello All

Was wondering if any one can help me im am a bit stuck at the moment.
I am working on a warehouse stock program.

i have several tables
1:) tblStock
2:) tblStockLocationLink
3:) tblLocation
4:) tblCustomer
5:) tblOrders
6:) tblOrderDetails

Ok how i have it at the moment is i have a lot of stock in my stock table as and when something come in i put it in a location with how much came in.

Then when a order come in i want to take the stock from the location i put it in and update the amount left of the stock.

I have a query that show how much stock i have and in the same query how much i am taking of the product i created a Totals field in the query with
Total: [tblStocklocationLink]![QuantityIn]-[tblOrderDetails]![Quantity]
it shows the right amount left my problem is to update my table with the quantity left to the new amount

im using access 2007 and 2010
im a novice in access and all help will be appriciated
 
You should review this material to see if it relevant to your situation.
Good luck.

A jpg of your "data model"/structure may be helpful to readers.
You can post a jpg of your tables and relationships, if you zip your file.
 
Thank you for your help i will look into it as it seems to explain exactly where i am and what i need :)
 

Users who are viewing this thread

Back
Top Bottom