AnsweredAssumed Answered

HOW TO UPDATE CALCULATED FIELD EVERY TIME I ENTER NEW RECORD

Question asked by larosa.karim on Jun 19, 2018
Latest reply on Jun 20, 2018 by k-meson

Guys can you help me with my problem.. i know its very easy to the expert, here it goest

 

I HAVE TWO TABLE

TABLE 1 - ORDER

     and the fields are : ORDER_ID, ORDER_QTY, ORDER_CALCULATEDQTY

 

ORDER_ID  - SERIAL NUMBER AUTO INCREMENT

ORDER_QTY - NUMBER

ORDER_CALCULATEDQTY - CALCULATION (ORDER::ORDER_QTY - DELIVER::DELIVER_QTY)

 

TABLE 2 - DELIVER

     and the fields are: DELIVERY_ID, DELIVER_QTY, FKORDER_ID

 

DELIVERY_ID - SERIAL NUMBER AUTO INCREMENT

DELIVER_QTY - NUMBER

FKORDER_ID - TEXT (THIS FIELD IS RELATED WITH ORDER::ORDER_ID)

 

-----------------------------

My Problem is: When i make ORDER of 20...then i DELIVER 10.....so there will be ORDER_CALCULATEDQTY, and that is 10.. or balance..

 

But the Next time i make DELIVER 10... the ORDER_CALCULATEDQTY, is not updating.. btw im entering same FKORDER_ID...but different DELIVERY_ID

Outcomes