This is what I would like to happen.
A combo box in a form, when pulled down, displays the Client Name, but stores the Client ID in the Table.
Attempting a simple database for a friend. Thanks for your help. I am using Access 2007.