Skip to Content
0
Former Member
Jan 06, 2012 at 03:53 PM

FMS attached to two events

33 Views

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!