title: Why is my Access Form Changing my Fields when I save it?
body: <p>I'm relatively new to Access and I'm working on putting together a database for a sports league. I have 2 tables that are set out like the following:</p>
  
  <p>Table 1 - Teams:</p>
  
  <ul>
  <li>Team_ID (autonumber, Primary Key)</li>
  <li>Name (Short Text)</li>
  </ul>
  
  <p>Table 2 - Results:</p>
  
  <ul>
  <li>Game_ID (autonumber, Primary Key)</li>
  <li>Home_Team_ID (Foreign Key from Table 1)</li>
  <li>Away_Team_ID (Foreign Key from Table 1)</li>
  <li>Winning_Team_ID (Foreign Key from Table 1)</li>
  </ul>
  
  <p>I've made a form that displays the Home/Away/Winning_Team_ID's from Table 2 however I'm really struggling to display the Team Names (from the link to the Table 1).</p>
  
  <p>In the Record Source for the form, I've linked Table 2 to three copies of Table 1, and then linked the Primary key's from the three Table 1's to the Foreign key's (Home/Away/Winning_Team_ID's) to Table 2 as seen below.</p>
  
  <p><a href="https://i.stack.imgur.com/TZqea.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/TZqea.png" alt="Record Source"></a></p>
  
  <p>This gives me the exact data I need when I go to View the results from this query.</p>
  
  <p>The issue is, when I try to "Add Existing Fields" into the Design View of the form and then save it, all 3 (Home, Away and Winning) show the same value (The Home Value).</p>
  
  <p>Before I save - Exactly what I need:
  <a href="https://i.stack.imgur.com/Ji2nY.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/Ji2nY.png" alt="Before Save"></a></p>
  
  <p>After I save - Field on the right has changed:
  <a href="https://i.stack.imgur.com/TVAHZ.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/TVAHZ.png" alt="After Save"></a></p>
  
  <p>(Note: The difference between the 2 above images is the change from <code>"Teams_1.Name"</code> on the right, to <code>"Teams.Name"</code>)</p>
  
  <p>I have no idea why, when I save it, it changes to the above automatically. If I add the fields and don't save and just go to layout view, it works perfectly, but as soon as I save it it changes all of the fields to the same one.</p>