I have a database that contains a value list that is made up of values from a field (Person's Name) in one table.

In a layout for a related table, I have a drop-down list that uses the value list.

Recently I noticed that some of the items (Names) that should be in the value list/drop down list do not appear. I have the value list to sort the names, so when selecting the drop-down list I see names in ABC order. The names that do not appear are towards the end of the alphabet (ex: Walter Smith.) However if I change the name of Walter Smith to AWalter Smith, it then shows up, but then one of the names that previously showed up at the bottom is not there anymore.

The table that the value list populates from only has 807 records. I dont think there is a limit to the number of values you can have in a drop down list, or at least not one I've encountered before or have been able to find in any documentation.

I do know it is not a problem with the value list because if I cahnge the field to a popup menu instead i do see all of the Names! I need to keep using a drop-down list because the list is so long (800 + values) it takes forever to scroll through a popup menu, especially since you cant start to type the first part of the name and have it move down to that section in the menu.

Any ideas on whats going on?

Can you try to take off the index of the value list field and then place it back on forcing FMP to recreate the index?

I just turned off indexing for the field that is used to populate the value list, then turned indexing back on. Unfortunately that did not resolve the issue.

rats! guess it is something else - you are right it is not the number of entries though.

May see odd but try rebooting the box.

Hey Beckham, I had the exact same issue before, and unfortunately nothing I did would fix the problem. Weirdly, I re-created the exact same database with everything the same, and it then worked fine.

lol, I got exactly the same problem but I wanna to try upgrading filemaker to the latest version and see whether it works anot.

Check this and see if that helps:

http://forums.filemaker.com/posts/f70946a9c9?commentId=192286#192286

 

This only applies to FM 12, though.

http://help.filemaker.com/app/answers/detail/a_id/10084/~/miscellaneous-behavior-changes-in-filemaker-pro-12