Hi, this question regards Access 2010.
A little orientation to the table and field names relevant to my question.
- The first table is called Clients.
- The Primary Key field for the Clients table is an AutoNumber field called ClientID.
- The other two relevant fields in this table are ClientFirstName and ClientLastName.
- The second table is called Contacts.
- In the Contacts table is a foreign key field, bound to the ClientID field from the Clients table, and also named ClientID.
On the Contacts table, the ClientID field properties are set on the Lookup tab as follows:
Display Control: Combo Box
Row Source Type: Table/Query
Row Source: SELECT clients.ClientID, clients.ClientFirstName, clients.ClientLastName
Bound Column: 1
Further, in the Row Source's Query Builder, ClientFirstName and Client LastName both have Ascending selected as Sort criteria.
Everything works as intended: When entering data into the the Contacts table (actually, the data is entered via a form built from the Contacts table) the data entry person can click the drop-down on the combo box for the ClientID field, scroll through ClientID records, and see unique ID numbers sorted by first and last names. And the actual data for the field is stored properly as the unique ClientID number.
Okay, sorry for the long preamble, just trying to provide an overview before asking my question. So here it is: When entering ClientID data into the Contacts table (or form), is it possible to enable autofill based on ClientFirstName and ClientLastName, rather than ClientID? For instance, let's say we have a few clients named Joe Smith. It would be great to just start typing "Joe Smith," and have the field autofill the ClientID number for the first client named Joe Smith. The intention is to make data entry a bit quicker.
If anyone has other suggestions or solutions, I'm open to those, as well.
Thanks!