BobTheBuilder
New member
- Local time
- Today, 15:53
- Joined
- Nov 26, 2011
- Messages
- 5
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 amounts according to how many PC's ordered.
Can anyone please help?!
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 amounts according to how many PC's ordered.
Can anyone please help?!