title: Foreign key relationship with composite primary keys in SQL Server 2005
body: <p>I have two tables </p>
  
  <pre><code>Table1(
    FileID,
    BundledFileID,
    Domain)
  </code></pre>
  
  <p>and </p>
  
  <pre><code>Table2(
    FileID,
    FileType,
    FileName)
  </code></pre>
  
  <p>In Table2 <code>FileID</code> and <code>FileType</code> are the composite primary key. I want to create a foreign key relationship from <code>Table1.FileID</code>  to <code>Table2</code>. </p>
  
  <p>Is it possible to do this?</p>