title: One to one relationship visual studio 2010 diagram between key and nonkey
body: <p>Hi I have these two tables:</p>
  
  <pre><code>Client:
  
      -IdClient: primary key
      -Name
      -IdAccount
  
  Account:
  
      -IdAccount: primary key
      -Total
  </code></pre>
  
  <p>I one to create a 1 to 1 relationship using IdAccount from Client table and IdAccount from Account table. I read that onley 1 to 1 relationships can be done in Visual studio between keys, in this case IdClient-IdAccount, how can I make a one to one relationship with IdAccount and IdAccount? If I make one it does it as 1 to many =S</p>
  
  <p>Thanks!</p>