Jump to content
Claris Engage 2025 - March 25-26 Austin Texas ×
The Claris Museum: The Vault of FileMaker Antiquities at Claris Engage 2025! ×

This topic is 4180 days old. Please don't post here. Open a new topic instead.

Recommended Posts

Posted

Forgive me if I'm wrong but I was under the impression that when using the LIst(field) function to combine multiple records into one field, that the sort order was meant to be defined by the sort order set in the relationship.

 

I've had this working before, but for some reason it doesn't seem to want to do it anymore, and is always reverting back to the order of when the records were generated.

 

I've attached an example here, where i eneterd the data in this order: ONE, THREE, FIVE, TWO, FOUR (with each record having a number field corrsponding to the word to use to sort on: 1,3,5,2,4).

 

As youcan see the portal sorts correctly, but the COMBINE (List) field which uses the List function does not, even though the sort order of the relationship is set to the number field.

 

Whats even ore odd is that I managed to get this to work in two other solutions, though both of them initially didn't work, but onceI had put the portal on the page, the COMBINE (List) field then reverted to sorting acorrding to the relationship sort order ?????

 

Any help greatly appreciated

 

FM 12.3

 

 

test2.fmp12.zip

Posted

You're using the right field, but from the wrong TO. Upper dialog: your sort order; lower dialog: correct sort order.

 

 

post-80889-0-30291600-1376488511_thumb.p

This topic is 4180 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 account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...

Important Information

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