Mr. John wrote:

> Thanks Alexandre,one question: in your code why UPDATE will not fire also,because you delete 'current' record

Because an UPDATE trigger just fires for the UPDATE operation, not for
DELETE's.

see you !

--
Alexandre Benson Smith
Development
THOR Software e Comercial Ltda
Santo Andre - Sao Paulo - Brazil
www.thorsoftware.com.br