title: SQL Server (2008) Creating link tables with unique rows
body: <p>I'm having trouble getting in touch with SQL Server Managemen Studio 2008! I want to create a link-table that will link an Event to many Audiences (EventAudience).</p>
  
  <p>An example of the data that could be contained:</p>
  
  <h2>EventId  |  AudienceId</h2>
  
  <pre><code>  4              1
    5              1
    4              2
  </code></pre>
  
  <p>However, I don't want this:</p>
  
  <h2>EventId  |  AudienceId</h2>
  
  <pre><code>  4              1
    4              1
  </code></pre>
  
  <p>I've been looking at relationships and constraints.. but no joy so far!</p>
  
  <p>As a sneaky second part to the question, I would like to set up the Audience table such that if a row is deleted from Audience, it will clear down the EventAudience link table in a cascading manner.</p>
  
  <p>As always, ANY help/advice appreciated!</p>
  
  <p>Thanks
  Pete</p>