AnsweredAssumed Answered

Changing a 'protected' field...

Question asked by synergy46 on Jul 16, 2009
Latest reply on Jul 17, 2009 by raybaudi

Title

Changing a 'protected' field...

Post

I have a table called SALES:

It has these fields:

 

      Type: (Dropdown value list "Buy" "Sell"

      Price:

      Qty:

      Total:

 

The TOTAL field is a calculated value that is Price * Qty.  (It is not 'enterable' because "enter in browse" is turned OFF in setup)

 

I would like to change  the value of TOTAL TO A NEGATIVE NUMBER if Type is "Sell".

 

I tried a script trigger but since TOTAL is 'protected' I can not write to it.

I do not want to 'clutter' the data by changing price or qty to a negative number.

 

Got any ideas?

 

Outcomes