Recent content by BobTheBuilder

Thanks Mark, I've found this extremely helpful!! :D

ah I see.. looks exactly like code that would help for sure. I think where it gets more complex for my required code is the a calculation similar to: amount = amount - (quantity * 2) if that makes any sense?

I want to edit values in several fields in tblStock dependant on order quantity placed in tblOrders

Hi, thanks for the message, does make sense.... only that its not a database that calculates transactions, but is more to monitor production; therefore stock levels are monitored and caluculated in relation to the volume of orders placed. the tblStock is simply there to hold the values of...

Hi, I'm trying to create a way to calculating stock levels in a database. I want to be able to place an order in tblOrders for 2 PC's and have my database decrement the stock amount in tblStock of 3 record fields (motherboard, RAM, network card)....... I need the stock amount to reduce...