Copy Code Trigger Definition 

                
                    CREATE trigger [dbo].[TR_SALESORDERITEMITINERARYITEMSTAFFRESOURCE_DELETE_SALESORDERITEM] 
                        on [dbo].[SALESORDERITEMITINERARYITEMSTAFFRESOURCE] 
                        after delete not for replication
                        as begin
                            delete from dbo.SALESORDERITEM
                            from deleted
                            where dbo.SALESORDERITEM.ID = deleted.SALESORDERITEMID
                        end