Copy Code Trigger Definition 

                
                CREATE trigger TR_RELATIONSHIP_INSERT_BBNCRELATIONSHIPIDMAP on dbo.RELATIONSHIP after insert not for replication
                as begin
                    insert into dbo.BBNCRELATIONSHIPIDMAP (RELATIONSHIPID)
                        select ID from inserted
                end