AnsweredAssumed Answered

Adding a field to another one, depending on its status

Question asked by PatrickHolzer on Feb 19, 2009
Latest reply on Feb 23, 2009 by Jade

Title

Adding a field to another one, depending on its status

Post

Hi,

 

I have a field called current_stock which displays the quantity of a specific product that we currently have on stock.

 

I have a table called "Inbound Orders" (which handles what we order from the manufacturer in order to sell it to customers); this table contains - among others - two fields: inbound_order_quantity and inbound_order_status.

 

Question:

 

How do I add inbound_order_quantity to current_stock if the status of inbound_order_status changes from "pending" to "completed" - because if it is "completed", that means we have received the goods and have taken them on stock - ?

 

Thank you!

- Patrick

Outcomes