basic combo box question

  • Thread starter Thread starter Christopher
  • Start date Start date
C

Christopher

When I select an item from my combo box list, the primary
key ends up in the field, not the data I chose. Seems
there's a simple solution.
What is it?
 
When I select an item from my combo box list, the primary
key ends up in the field, not the data I chose. Seems
there's a simple solution.
What is it?
Click to expand...

It's the primary key value that you want to store. In reports and queries, you
can display the other values in the record identified by that primary key by
including the items' table in the query and joining those key values. Then you
can add the desired fields from the item's record to the query grid to display
the value in your query or report.
 
Back
Top