basic combo box question

[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?

 

[Bruce M. Thompson]

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?

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.