Sort List(field) Calculation Results

[dztrucktion]

My FM solution has 2 related tables, one that contains Cues and one that contains Composers. The cues have a primary composer and a secondary composer, which is combined and related to the Cues table via a calculation field using List(field) function. Everything is returning fined, but is there an elegant way of sorting these values in the calculation to always the primary composer first and the secondary composer second?

Substitute(List(Composer::Fullname); ¶; " / ")

Thanks,

d

[comment]

Sort the relationship (I think - I am not quite sure I understand what you describe).

[dztrucktion]

The sort relationship won't work because a Primary Composer and Secondary Composer aren't fixed, meaning their role changes per Cue.

I guess the question would be, is there a way to sort the returned values in a List(field)?

[comment]

Please explain exactly how the two tables are related.

[dztrucktion]

There are actually 3 tables.

Composer

Cues

Composer Role

Composer is related to Composer Role via RecID and Cues is related to Composer Role. I am using Composer Role to tie the 2 tables together and a new record is created every time that a new track is assigned a primary and secondary composer. I am pulling the relation from Composer Role, this way every new track can have a different Composer Role independent of a composer's last role.

I am trying to pull the Composer full name into the Cues table via the Composer Role table with a calculation field in the Cues table in the order of Primary Composer / Secondary Composer.

Apologies for the mis-info.

[comment]

I see. You want to pull the list from Composers, but have it sorted by a field in Cues. That's not going to work - see:

http://fmforums.com/forum/showpost.php?post/291896/

However, you could place the name calculation in the Roles table and point the List function to it - with the relationship Cues -< Roles being sorted on the Roles side by the role field.

[dztrucktion]

Perfect! Thanks!