title: Microsoft Access - The field 'column bound' doesn't work properly
body: <p>I have problem with the 'column bound' option.</p>
  
  <p>I want to create a combo box so that the field will show an other table field, and when I open the box it will show the first 3 columns. When I choose the row, I want it to save the 2nd value.</p>
  
  <p>For that I defined the field like this:</p>
  
  <ol>
  <li>Display control - combo box </li>
  <li>Row source data - Table/Query </li>
  <li>Row source - Customers </li>
  <li>Bound column - 2 ; column count - 3 </li>
  </ol>
  
  <p>When I click and chose a row from the list that roll down, it shows me the first column value in the cell, instead of the second column value.</p>
  
  <p>Can someone help me figure out the problem? (I check the field type and its fine - text)</p>
  
  <p>Thanks in advance,
  Gal :)</p>