Enter Text into a Pop Up Field to quickly find matching record
I have several data field that access various employee's full names from related tables in a master data entry table. The employee first, middle, last and suffix is referenced in one pop up field, using the proper punctuation, etc for the master screen. During data entry, the operators would like to simply type part of the name instead of having to use a mouse scroll and click to access the name.
It took me a good many tries to get the pop up fields working seamlessly. From what I read, pop up fields are simply mouse oriented. If I change the field to a drop down, the field is then populated with the Primary Key of the related record instead of the full name as described above. Is there a way to make this work without using pop up, but still having the name populate from multiple fields?
I will include a snapshot of the field and the related table structure.
Thank you in advance for your help!