TR_REVENUESPLIT_EXT_DELETE

                CREATE trigger TR_REVENUESPLIT_EXT_DELETE on dbo.REVENUESPLIT_EXT after delete not for replication
                as
                begin
                    update dbo.INSTALLMENTSPLIT
                    set INSTALLMENTSPLIT.REVENUESPLITID = null
                    from deleted
                    where deleted.ID = INSTALLMENTSPLIT.REVENUESPLITID
                end