Sign in to follow this  
Followers 0
reynir

List function

6 posts in this topic

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.

Share this post


Link to post
Share on other sites

The list function uses the sort order of the relationship; not the sort order of the portal.

Share this post


Link to post
Share on other sites

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.

Share this post


Link to post
Share on other sites

I am working on this database in FileMaker Pro 11 :-( with my client.

 

I will take a look at the relationship.

 

Regards,

Reynir.

Share this post


Link to post
Share on other sites

Sorting the relationship did the trick.  Thank you for your time.

Share this post


Link to post
Share on other sites

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!

Share this post


Link to post
Share on other sites

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 account

Sign in

Already have an account? Sign in here.


Sign In Now
Sign in to follow this  
Followers 0