The result of List(field) comes out in record creation order.

Is there any trick to control that?

I'm populating a single calculated text field in the main file with a list of field data from a 'many' relationship (thru a join table), and would like to allow the user to control the sort order of the result by modifying a field within the table the list is pulled from.

Looking into "create a value list based on values of the field in question, make it a conditional value list based on the relationship ID... then use ValueListItems() to return only the unique values. Works best in a script."

That worked.

As the target field to make a list from was a calculated text block, itself with a list from yet another field, : , I had to replace all ¶ with # so I could sort the field as a single item, then subbed them back after using VLI().

Edited August 29, 201015 yr by Guest
Solved.

The result of List(field) comes out in record creation order.

This is true only if the relationship isn't sorted.

LOL! Your English was perfect. Where were you an hour ago? (and why did I not think to try that). Thanks!

I still needed to sub out the ¶ for # to maintain my text blocks, so not truly a waste of time.

There is even to say that the relationship's sort could be modified programmatically by changing the value of a summary field and sorting that relationship by the summary field.

Sort_the_rel.zip

Any difference?

NoSummary.zip

What did you aspect from a ChindoguMaker ? :

:funnypost: