3 Replies Latest reply on Jan 14, 2014 12:55 PM by philmodjunk

    Enter Text into a Pop Up Field to quickly find matching record

    LoyleneRuppert

      Title

      Enter Text into a Pop Up Field to quickly find matching record

      Post

           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!

      Screen_Shots.png