And are you using Mac or Windows? As far as I know, this does not work in Windows.
Even a drop down list with this value list won't work the way you want though there is a way to hide the ID number and display the name field.
You may find this demo file of interest:
FileMaker 12 users: https://dl.dropbox.com/u/78737945/SimpleNameLookupDemo.fmp12
Pre FileMaker 12 Users: https://dl.dropbox.com/u/78737945/SimpleNameLookupDemo.fp7
I am using Windows. I may resort to just using a standard drop-down list, but I'll take a look at the file you shared and see if that'll work for me.
So...I have this exact same problem. We've had an all Mac interface for the past 3 years and no issue on a popup menu selecting a vendor on a product by being able to both scroll the list and select to a section of the list by hitting a letter. We recently added a PC to the database and now they can not do this. So my questions are 2 fold:
1) Is there a fix to this? Why would it not work the same on a PC as a Mac? We love the functionality and would prefer to keep it the same.
2) If my only option is to write a script, can I get some help on this? I know how to make a new script and pull up the vendor layout, but I am a little confused how to now make that field be populated with a vendor from a list that is appearing in a 2nd window?
The attached databases didn't quiet simulate for me how I get to where I need to go.
Please and Thank You
I've never been able to fix this issue on my PC, and haven't gotten around to making a script for it yet. My end solution was to just use a dropdown menu, but I tweaked the way the database was handling the relationship between the two tables, and that fixed my serial number issue.
The primary reason it doesn't work the same on PC and Mac is because FileMaker is a Mac program that has been adapted to Windows. Although there may have been an updated that fixed this, or a new program version (FMP13) that may have fixed this, from what I know FMP12 still has the same issue on Windows, and it's going to stay that way unless it was fixed in an update.
Sorry about that.
Yeah it's been confirmed (on another forum) that FM13 still has this problem. Care to shed some light on how you made dropdowns work? Whatever I do I always see the ID # and not the company name.