title: table relationships, SQL 2005
body: <p>Ok I have a question and it is probably very easy but I can not find the solution.</p>
  
  <p>I have 3 tables plus one main tbl.</p>
  
  <pre><code>tbl_1 - tbl_1Name_id 
  tbl_2- tbl_2Name_id 
  tbl_3 - tbl_3Name_id
  </code></pre>
  
  <p>I want to connect the Name_id fields to the main tbl fields below.</p>
  
  <pre><code>main_tbl 
  ___________ 
  tbl_1Name_id 
  tbl_2Name_id 
  tbl_3Name_id
  </code></pre>
  
  <p>Main tbl has a Unique Key for these fields and in the other table, fields they are normal fields NOT NULL. </p>
  
  <p>What I would like to do is that any time when the record is entered in tbl_1, tbl_2 or tbl_3, the value from the main table shows in that field, or other way.
  Also I have the relationship Many to one, one being the main tbl of course.</p>
  
  <p>I have a feeling this should be very simple but can not get it to work.</p>