Your users can pick a customer by name while Access stores the matching CustomerID. Put the ID first in the combo box’s list, bind to column 1, and hide that column so the name is displayed instead. My Relational Combo video shows how to build this using a table or query and save the selection in a service record.

For a complete step-by-step video tutorial on this topic, including additional examples and explanations, please visit https://599cd.com/1752.