Combo box results show as Primary ID, not alpha data

[wolfm]

I have a table called ‘Orders’. I have a form called ‘Orders’, which has a combo box containing names of people that can place orders. This combo box pulls names from a table called ‘Requestors’.
When entering an order, the combo box correctly pulls and displays the name. When I run a query called ‘Orders’ the field Requestors shows the Primary ID of that name, not the name itself. When I run a report off of this query, I get the Primary Key as well.


How do I get the query, or at least the report, to show the name instead?
The settings for my Requestor combo box in the form is: Column Widths: 0";1.325" Column count: 2 Bound column:1
When creating the combo box, I hid the primary key, and indicated to have the value stored in the Requestors field in the ‘Orders’ table.
Can anybody help? Hopefully, I was clear enough?

[pbaldy]

You join the requestors table to the orders table, enabling you to return the name field.

[wolfm]

OK, thank you!!

[pbaldy]

No problem, post back if you get stuck.