title: Microsoft Access - Integrity through relationships
body: <p>I had a question about relationships in Access 2010. I have 2 tables:</p>
  
  <pre><code>Table 1       Table 2
  
  ID Name       ID Name
  1  George     1
  2  Linda      2
  3  Frank      3
  </code></pre>
  
  <p>Where I purposely left name in table 2 blank because I want to enforce a relationship between name in table 1 and name in table 2 with referential integrity.  Currently if I enter a name into table 2 that is not in table 1 it does not catch it as an error. I want there to be data validation and I thought relationships was the way to do that.  Am I understanding referential integrity wrong?</p>