One question... is possible to update a field that have a FMS attached when 2 event's happens?
For example, I want to change the value of the commission % column when the user change the sales employee drop down list and when the user add a new line to the sales order... in this moment only works when I change the Sales employee, wen I try to add a new row it dont fill in the right commission %.
SELECT DISTINCT
CASE
WHEN $http://ORDR.SlpCode=6 THEN 6
WHEN $http://ORDR.SlpCode=7 THEN 7
WHEN $http://ORDR.SlpCode=8 THEN 8
WHEN $http://ORDR.SlpCode=9 THEN 9
WHEN $http://ORDR.SlpCode=-1 THEN -1
ELSE 0
END
FROM RDR1
WHERE RDR1.ItemCode = $http://RDR1.ItemCode
Thank you!