title: Microsoft Access 2010 - Foreign Key as Dropdown
body: <p>I have two tables that I display in a form:</p>
  
  <p>tblUsers -> user_id, firstname, lastname, group_id</p>
  
  <p>tblGroups -> group_id, groupName, groupDesc</p>
  
  <p>I can get the data that I want with:</p>
  
  <p>SELECT tblUsers.firstname, tblUsers.lastname, tblGroups.groupName
  FROM tblGroups INNER JOIN tblUsers ON tblGroups.[group_id] = tblUsers.[group_id];</p>
  
  <p>But what I need is a form that shows the user information and a dropdown list for the group but showing the name of the group not the ID and so the group can be changed for a specific user e.g. Manager, Editor  etc...</p>
  
  <p>Thanks,
  Gareth</p>