Type Client Name (using Auto-Complete) and Get Client ID
I have a database with Clients and Invoices. There is the possibility of a large number of clients, so clean data entry is a must.
On the Invoice layout, I would like to start typing the client name (using auto-complete) and have the Invoice table's Client ID field populated with the correct primary key from the Client Table once the client is entered. I need to have the Invoices that are created to be linked back to the client so they can be shown in a portal.
This seems so simple to me, but I've been unable to get all the pieces in place. The closest that I've come to this is to set the Invoice table's Client ID (secondary key) to display the client names and actually store the ID number, but this is confusing and auto-complete doesn't work.
I'm sure that this has been asked before, but I've been unable to locate any relevant threads or methods. If anyone can point me in the right direction, it would be much appreciated.