title: Use Trigger to insert value when Value is inserted into any column in another table
body: <p>I have a GenreTable: </p>
  
  <p><img src="https://i.stack.imgur.com/9gT4Y.png" alt="enter image description here"></p>
  
  <p>I have a "CombinedTable":</p>
  
  <p><img src="https://i.stack.imgur.com/SMx3o.png" alt="enter image description here"></p>
  
  <p>I have a trigger:</p>
  
  <pre><code>ALTER TRIGGER [dbo].[trgAfterUpdate] on [dbo].[Genre]
  AFTER UPDATE
  AS
     INSERT INTO [dbo].[CombinedTags]([Combined])
  
     SELECT TOP 1 PodcastGenre
     FROM Genre
      ORDER BY rowID DESC
  </code></pre>
  
  <p>I am trying the trigger so that when a value is in ether of the columns in the "GenreTable" [(MovieGenre), (MusicGenre), (PodcastGenre)] </p>
  
  <p>It inserts the "RowID" into the "ForeignRowID" column of the "CombinedTable" AND the "value" that's being inserted into ether of the columns of the "GenreTable" into the "Combined". Thank you for your help.</p>