Calculation, Lookup, Best Way?

[tyler_tdf]

Currently I have two tables, Clients and Jobs. Clients is related to jobs through ClientID. Both tables have an auto enter serial field, ClientID and JobID. In the Jobs table ClientID is set as a pop up list, listing the clients entered in the Client table.

Eventually though there will be 300 + clients to choose from in that pop up list. Rather than scroll through that many, I want to be able to manually enter a client name and have a function that will lookup the correct clientID. Right now that only works if I specifically select it from the pop up list. If I simply manually enter the name and tab through clientID field in the Job table, it creates a new ID, and duplicates that client.

I'm attaching a sample file as well.

Any ideas?

Thanks!!

tyler_tdf_help.zip