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
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

2

3

4

5

6

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