AnsweredAssumed Answered

Auto-Complete Lookup

Question asked by jerrypayne on Aug 17, 2016
Latest reply on Aug 19, 2016 by philmodjunk

Hello FM Community,


I have been programming in MS Access for years, but I am new to FM.  My apologies, if i get FM terminology confused...


Q:  i have an 'Equipment' layout with an 'Owner' popup list.  The list provides the owner names to Users, but stores the OwnerID in Equipment table.  I want to update the functionality to 'auto-complete' for the end users.  the rules indicate that i have to convert popup to either an editbox or drop-down list.  i also have to change the type to text.  When i do this, the value that i am trying to store is shown in my list not the name that i want to search.


Is it possible to show the Owner names in the text control while using auto-complete, and store the ID?  do i need to add another control box?


Thanks in advance,