How familiar are you with setting up value lists in FileMaker?
Do you know how to use the specify field option to set up a value list where ID numbers are in field one and names or other data is displayed in field 2?
Know the differences and limitations to drop down lists, pop up menus and "Show only values from second field" and "sort values using second field"?
Those are the basics and if you are familiar with them, you'll know that you can't auto-complete on a value list where the ID number is selected as field 1.
Do you know how to create scripts?
That distressing limitation is why I came up with a scripted approach that does provide an auto-complete enabled drop down list of names, but uses a script to take that text to find and enter the ID number of the related record--with code to handle issues such as duplicate names. I uploaded a demo file that showcases that technique and then throws in a few search portals for comparison purposes:
I think that you have described exactly what I am looking for. I cannot, however, reach that website (our firewall). Is there another way you could share the information with me?
You have accessed a very old thread. I stopped using that site due to the scuzzy download links that misrepresented themselves and the fact that I was getting malware warnings from my antivirus software when I accessed that site.
Try this link: