My data base contains 3 tables we will call them "IntoStock", "OutOfStock" and "CurrentStock"
IntoStock contains records of all items ordered for stock, OutOfStock contains records of everything taken from stock and booked to a job.
I want to automaically update the current stock quantitly when anything is booked in or out of stock. I have tried the update query method using DSum where the item descriptions match, however the error "Operation Must contain an updateable query" comes up so I guess the syntax is wrong or even the whole principal of what I am trying to do.
Please assist me!