Changing a 'protected' field...
I have a table called SALES:
It has these fields:
Type: (Dropdown value list "Buy" "Sell"
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?