Display forename & surname instead of id in combo box. (2 Viewers)

I've been trying to figure out how to do this but since I'm not familiar with Access terminology, it's proving to be difficult.

I will attach my database to this post, but the general setup of my database is as follows:

• I have 3 tables; Mechanics, Customers & Appointments.
• Each has an AutoNumber primary key called "id".
• The Appointments table has "mechanic" & "customer" fields that reference the "id" fields from the other two tables.

I need to have a form setup to add records to each table. Creating these for Mechanics & Customers went very smoothly, but figuring out how to display something other than the "id"'s when adding an Appointments record did not. To clarify, I would like to see the Customer/Mechanic's forename and surname instead of their "id" when using the form labelled "Appointments Form".

Thank you!

The trick is to return the ID column and then the column you want to see.
Hide the first and show the second.
Something like
Bound column: 1
Number of Columns: 2
Column Widths: 0";1"

First column is bound but it is hidden.

To be clear it is hidden because it has a width of zero.

Have a look at the customer drop down now.

Look at the combo properties and compare to the mechanics one for the differences.