reynir Posted March 14, 2013 Share Posted March 14, 2013 Hi I have a portal showing upper and lower limits of measurements. The portal is sorted by FK_MeasurementsID Then I have a list showing the upper limits List(Measurements::UpperLimits) also for lower limits My problem is that the List() function does not sort the upper and lower limits the same way as the portal. Then when I use those values they don't match. Does the List() function use the creation order of the measurements records? Is it possible to sort the List the same way as the portal? Regards Reynir. Link to comment Share on other sites More sharing options...
bruceR Posted March 14, 2013 Share Posted March 14, 2013 The list function uses the sort order of the relationship; not the sort order of the portal. Link to comment Share on other sites More sharing options...
jbante Posted March 14, 2013 Share Posted March 14, 2013 Since you're using version 12, you have access to the ExecuteSQL function, which you can use to get data from a list of records sorted however you want. You can read more about it in The Missing FM 12 ExecuteSQL Reference. Link to comment Share on other sites More sharing options...
reynir Posted March 19, 2013 Author Share Posted March 19, 2013 I am working on this database in FileMaker Pro 11 :-( with my client. I will take a look at the relationship. Regards, Reynir. Link to comment Share on other sites More sharing options...
reynir Posted March 19, 2013 Author Share Posted March 19, 2013 Sorting the relationship did the trick. Thank you for your time. Link to comment Share on other sites More sharing options...
Kriski Posted May 22, 2013 Share Posted May 22, 2013 The list function uses the sort order of the relationship; not the sort order of the portal. Bruce, thank you so much for this response, ithelped me work out what I'm doing! Link to comment Share on other sites More sharing options...
Recommended Posts
This topic is 3963 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