Trigger dbo.L_GLTax_UTrig

CREATE TRIGGER L_GLTax_UTrig ON L_GLTax FOR UPDATE AS
/ *
* CASCADE UPDATES TO ´D_GLJournal´
* /
IF UPDATE(TaxCode)
BEGIN
UPDATE D_GLJournal
SET D_GLJournal.TaxCode = inserted.TaxCode
FROM D_GLJournal, deleted, inserted
WHERE deleted.TaxCode = D_GLJournal.TaxCode
END

Updated On: 05.04.01