A better view of the relationships...
IF you use a portal to collaborators (NOT identities) with identities::name included in the portal row, you can either sort the portal or the relationship by naming_order and they will appear in the portal in that order.
This woked wonderfully for the portal! I can't believe I didn't try this while troubleshooting. I have one more area where I still may need some help. I also have a calculation field, in the proposals table, that takes the list of authors, and creates an 'authors_list'. This idea behind this list is that the authros names will be listed together (compact) in a single line of text. The 'authors_list' caluculation, which lives in the 'proposals' table, looks something like this:
Field Name Type Options / Comments authors_list Calculation Unstored, = Substitute( List(identities::full_name); "¶"; "—")
I still cannot get this list of authors, displayed in the correct order (naming_order). We would like to use this compact list for our program printing layout. Any ideas?
Put a calculation field in collaborators that simply copies the name from identities.
Specify your sort order for the relationship, not the portal on which it is based.
Then modify your calculation to list this new calculation field instead of full_name.
The calc field, cFull_name defined in Collaborators:
and authors_list then becomes:
Unstored, = Substitute( List(Collaborators::cFull_name); "¶"; "—")
Your solution to my related problem worked like a charm! I am very impressed with the speed at which you deliver your spot on soulutions! Keep up the good work!