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

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