title: Access 2010 - display related record in a form
body: <p>I have 2 related tables.
  Invoice (fields: number, buyer, supplier, etc.)<br>
  Company - all buyers and suppliers (fields: name,etc.)<br>
  Buyer ans supplier fields on invoice are referencing same field (company_id from company table)
  <br><br>
  On invoice form, I choose supplier ID from dropdown list and also buyer ID from dropdown list.<br> 
  <strong>Task</strong>: To make the form little bit readable, I would like to automatically display a name of company after selecting company id in both fields. <br> 
  <strong>What I did</strong>:
  I manually dragged the company name field to the form and wizard asked me which field I would like it to connect to (byuer or supplier), so I got 1 field working. How to create another field that shows company name? If I drag another instance of company name, wizard does not show so I can set it up and I can not find anywhere setting for that. Thank you for help.</p>