Subject Re: tricky trigger
Author martinknappe
> I don't think this problem has anything to do with recursion and that
> the solution is very simple. BEFORE triggers should be used to modify
> the values of the current record, modifying other records should be
done
> in AFTER triggers. So just change BEFORE UPDATE to AFTER UPDATE and try
> again...
>
> HTH,
> Set
>

Yes thank you that was it!

martin