List function

[reynir]

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.

[bruceR]

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

[jbante]

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.

[reynir]

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

 

I will take a look at the relationship.

 

Regards,

Reynir.

[reynir]

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

[Kriski]

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!