title: The columns in 'table' do not match an existing primary key or unique constraint
body: <p>Consider two database tables, <code>tbl_One</code> &amp; <code>tbl_Two</code>.</p>
  
  <p><code>tbl_One</code>'s primary keys are: <code>A</code>, <code>B</code> &amp; <code>E</code> columns</p>
  
  <p><code>tbl_Two</code>'s primary keys are: <code>B</code> &amp; <code>C</code>.</p>
  
  <p>I don't want any values in table <code>tbl_Two</code> column <code>B</code> that do not exist in table <code>tbl_One</code> column <code>B</code>.</p>
  
  <p>Ideally, I want column <code>B</code> to be foreign key, but when I try to create this I get the following error message:</p>
  
  <blockquote>
    <p>The columns in table 'tbl_One' do not match an existing primary key
    or UNIQUE constraint.</p>
  </blockquote>
  
  <p>How can I achieve this?  </p>