BeckhamTX Posted February 11, 2010 Share Posted February 11, 2010 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? Link to comment Share on other sites More sharing options...
fmdevusa Posted February 11, 2010 Share Posted February 11, 2010 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? Link to comment Share on other sites More sharing options...
BeckhamTX Posted February 11, 2010 Author Share Posted February 11, 2010 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. Link to comment Share on other sites More sharing options...
fmdevusa Posted February 11, 2010 Share Posted February 11, 2010 rats! guess it is something else - you are right it is not the number of entries though. Link to comment Share on other sites More sharing options...
mr_vodka Posted February 11, 2010 Share Posted February 11, 2010 May see odd but try rebooting the box. Link to comment Share on other sites More sharing options...
Zcast Posted February 12, 2010 Share Posted February 12, 2010 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. Link to comment Share on other sites More sharing options...
ominae Posted February 22, 2010 Share Posted February 22, 2010 lol, I got exactly the same problem but I wanna to try upgrading filemaker to the latest version and see whether it works anot. Link to comment Share on other sites More sharing options...
IT_User Posted February 27, 2013 Share Posted February 27, 2013 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 Link to comment Share on other sites More sharing options...
Recommended Posts
This topic is 4096 days old. Please don't post here. Open a new topic instead.
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now