wasted Posted February 15, 2005 Share Posted February 15, 2005 I have a value list based on a relationship between two tables accounts and school districts. The field the list is based off of is a calculation. It combines the districts name and id. I need the list to be sorted alphabetically but I can't make it happen. How do I do this? Thanks Link to comment Share on other sites More sharing options...
-Queue- Posted February 16, 2005 Share Posted February 16, 2005 Have you tried including a second field in the value list definition, that being the related name field, and telling FM to sort based on it? You might also change the calculation to name & "_" & id instead of id & "_" & name? Link to comment Share on other sites More sharing options...
Recommended Posts
This topic is 7010 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