Define the field as a global field. That way the field contents can be accessed by a script while in find mode. Set it up with your value list of names, auto-complete is a good option to specify for this drop down list.
Then run this scritp from an OnObjectExit Trigger (or just put a button for it next to the field):
Enter Find Mode
Set Field [EmployeeInfo::Name ; EmployeeInfo::gName ] //gName is global field formatted with drop down list
Set Error Capture [on]
Which field do I make global? When I try making the name field a global field it won't let me use it as a value list? Is there a need for me to make a related field or can I do it all within the one layout?
You define a brand new field used solely for this search purpose.
In my example, EmployeeInfo::Name is the existing field in your table. EmployeeInfo::gName is a brand new field defined with global storage and formatted with the drop down and script trigger. (gName can actually be defined in any table in your system and this will still work. I often set up a Globals table strictly for managing all such global fields.)
Haha I figured that out right before you posted that! So I have that set up with the script trigger, the only thing now is that when I pick an employee in gName all of the other cells go blank, none of the other information for the record shows... thoughts?
Double check your script. I think you forgot to clear the "pause" option for the Enter Find Mode script step and your script is pausing in Find mode.
You are correct. Thanks so much for your help!