|Subject||Re: tricky trigger|
> I don't think this problem has anything to do with recursion and thatdone
> the solution is very simple. BEFORE triggers should be used to modify
> the values of the current record, modifying other records should be
> in AFTER triggers. So just change BEFORE UPDATE to AFTER UPDATE and tryYes thank you that was it!