How you show the list in the field?
Try to use a drop-down list instead of pop-up menu.
Then, pressing (for example) "F" on the keyoard, the list will scroll to the rows starting with "F".
This gains a lot of time even in very long list.
"Of course, once the index is created, they zip along OK."
Well, that seems to be an indicator. What exactly is slow - the display of the value lists once invoked? Are they always slow, or do they speed up after the first time they're called?
Is this a hosted database? If so, what kind of network - LAN, WAN?
How many fields are in the table from which the value list is drawn?
It may not be the indexes per se (because once a field is indexed, it's indexed), but loading the records to create the list over the network that's causing the problem.
It's hosted on a FileMaker Server, LAN and WAN.
Slow means waiting 20-30 seconds for the list to update and reveal itself. I can physically use the mouse to scroll through, but not use type-ahead to get down the list.
There are two fields in the table from which the list is generated: ClientID and Name
Even using a machine in the same office as the server (less distance, same network) shows a delay, though not so much.
All the best,
JB, The Creative One
What you're describing points to caching and latency. (Closer to server = faster speed). It smells like a network issue.
Is this value list relationally-based (i.e., contextual based on the current record)? Or is it "all records"? And again, is it zippy once you summon it once, or is it always slow?
Re: "I can physically use the mouse to scroll through, but not use type-ahead to get down the list"
This may be because you have the list set to sort by the ID field. If it is set to srot by the name field, or better still show only the name field, you can use type ahead to jump down the list. However there is a gotcha here: set this way the list will not show duplicates, so if you have more than one record with the same name only one instance will appear in the list. If you are going to use this approach you need to make sure the second field will givew unique values (a calc of first name + last name or similar).