Sort order of related fields via multi value key

Questions
1

(FMP 21.1.1.41 on Mac OS 13.7)
I am cataloging CDs.
One of my tables is "Albums" and another is "Artists".
Using a multi value key field in Albums, there is a link to Artists (k_AlbumArtist = a_PrimaryKey) to display Album Artists. This works well and gives the correct results.
However, when viewing the related records in a portal, they appear in the order in which the Artist record was created, not the order that they are listed in k_AlbumArtist. With using multiple names for an Album Artist, the order is important.
There is no sort defined in the portal and none in the TO.
Is this expected behaviour?

2

Yes!

Records are always displayed in creation order when no sorting is specified.

That said, there is no way to order based on the order of a multi-key value list. You would need to use a join table to achieve the sort order you desire.

Hope this helps.

3

Thanks for the clarification.
I do have an existing artist join table that I can edit for this purpose easily enough.
Cheers

4

@elmpine Welcome to The Soup Community !

5

You can create a field which is used to determine the sort order. This is usually a number field but it could be text. Then your can use the portal settings to sort the records by that field.

2 Likes