title: SQL Server Management Studio does NOT let me create multiple foreign keys to multiple primary keys
body: <p>I have a table <code>ApplicationRegion</code> in a one-to-many relationship to <code>Translation</code>.</p>
  
  <p>I want to set FK's from <code>Translation.appname/isocode</code> to <code>ApplicationRegion.appname/isocode</code></p>
  
  <p>But that did not work as you can see from the screenshot.</p>
  
  <p>When the FK configure window opens 3 columns are shown on the left/right side</p>
  
  <pre><code>appname
  isocode
  resourcekey
  </code></pre>
  
  <p>Then I chose as parent table <code>ApplicationRegion</code> and removed the resource key column from the FK setting.</p>
  
  <p>And clicked OK but then I got the error you see on the screenshot.</p>
  
  <p><a href="https://i.stack.imgur.com/74lQ4.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/74lQ4.png" alt="enter image description here"></a></p>
  
  <p>Finally I made it work with that workaround and I would like to know why I had to use this workaround?</p>
  
  <ol>
  <li>Remove PK from Translation.ResourceKey column</li>
  <li>Open FK configure window</li>
  <li>Only 2 columns appear now as foreign keys</li>
  <li>I click OK</li>
  <li>Now I add the PK again to Translation.ResouceKey column</li>
  <li>I added test data to all 3 tables and everything is fine.</li>
  </ol>
  
  <p>WHY this workaround?</p>
  
  <p><strong>UPDATE</strong></p>
  
  <p>HAHA...</p>
  
  <p><a href="https://i.stack.imgur.com/vDVRG.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/vDVRG.png" alt="enter image description here"></a></p>