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,