Jump to content
Sign in to follow this  
reynir

List function

Recommended Posts

reynir    0

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
BruceR    154

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
jbante    141

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
reynir    0

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
Kriski    0

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  

×

Important Information

By using this site, you agree to our Terms of Use.