1 Reply Latest reply on Jul 17, 2009 12:06 AM by raybaudi

    Changing a 'protected' field...

    synergy46

      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?