Getting drop-down list to show selected item from Value List instead of field
I have a Job form where we select the client from a drop down list. The list is keyed on ClientID but displays only Client Name.
Once the correct client is selected, the rest of the fields are auto-populated fine, except the Client Name field shows a number, the AutoIndexed ClientID field.
Is there any way to make it so that the field in the database still contains ClientID, yet when the form is displayed the field shows client name?