JD2775 Posted August 5, 2011 Posted August 5, 2011 I have a value-list field that contains values from another field in a related table. In the table the records show up as 2 5 4 3 6 8 1 10 7 In the value list, however, it sorts them 1 2 3 4 5 6 7 8 9 10 How can I set the value list to mimic the order they actually are in the table? Seems like it would be such an easy thing to do but I cant figure it out. Im using FMP10 if that matters. Thanks
comment Posted August 5, 2011 Posted August 5, 2011 No, it's not easy. As a rule, value lists using values from a field are sorted in ascending order (you actually see the index - that's why duplicates are removed too). See here for a limited workaround: http://fmforums.com/forum/topic/49445-value-list-sort-problem/
JD2775 Posted August 5, 2011 Author Posted August 5, 2011 Wow, it's not easy. Thanks for the link, Im gonna give that a shot
Recommended Posts
This topic is 4877 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