title: Assistance with combo box using lookup table - MS Access
body: <p>Basically what I have is a <code>Customer</code> Table which contains information about our customers.  One of the fields in this table is <code>Customer.CustomerTypeID</code>.<br>
  I have a <code>CustomerType</code> Table as well that is basically a lookup table.<br>
  I want the <code>CustomerType.CustomerTypeName</code> field to populate my combo box, then when I go to save my record I want the <code>CustomerType.CustomerTypeID</code> for the <code>CustomerType.CustomerTypeName</code> I chose to be updated in the <code>Customer.CustomerTypeID</code> field.</p>
  
  <p>Am I overcomplicating this?  Should I just change it so I'm storing the <code>CustomerName</code> in the <code>Customer</code> table instead of the ID?</p>
  
  <p>Thanks in advance.</p>