Trigger dbo.L_GLReport_UTrig

CREATE TRIGGER L_GLReport_UTrig ON L_GLReport FOR UPDATE AS
/ *
* CASCADE UPDATES TO ´L_GLReportItem´
* /
IF UPDATE(ReportID)
BEGIN
UPDATE L_GLReportItem
SET L_GLReportItem.ReportID = inserted.ReportID
FROM L_GLReportItem, deleted, inserted
WHERE deleted.ReportID = L_GLReportItem.ReportID
END

Updated On: 05.04.01