A value list of "Thousands of Records" isn't really practical to work with in any order. You may want to make it a conditional value list to reduce the length of the value list to a more reasonable length.
Value lists that specify the "use values from a field" option automatically sort in ascending order so there is easy way around that. I've been able to force small numbers of values into a different arbitrary order by using the second field as an invisible "sort" field, but this requires that the second field not be used for other purposes and isn't something that you can use with Thousands of values.
A selection portal may be your best bet. If you don't have space for one on your layout, you can pop one up in a small floating window or (if using FileMaker 13), a Popover.
"A selection portal may be your best bet. If you don't have space for one on your layout, you can pop one up in a small floating window or (if using FileMaker 13), a Popover."
I think this is the route i would like to go. Could you perhaps walk me through this process? A separate window with a selection portal would be great, but I'm not sure how to create a selection portal or a pop up window. Thank you as always
Start with getting a portal. Can you set up a portal that lists the values you would otherwise put in your value list? What data do you need to actually enter into your field? And ID number? A Year? or ??? Or do you just want to find that record?
Here's a demo file with three search portals shown across the bottom of the layout:https://www.dropbox.com/s/0pm1gdqcfi2ndpv/EnhancedValueSelection.fp7
If you are using FileMaker 12 or newer, you can use Open from FileMaker's File menu to open this file and produce a copy converted to the newer .fmp12 file format.
I just want to navigate quickly to a record for editing