AnsweredAssumed Answered

Sorting by 'second field'

Question asked by lourensjoubert on Apr 29, 2018
Latest reply on Apr 29, 2018 by Malcolm

Hi FileMaker Experts,

I'm hoping someone out there can point me in the right direction…


I'd like to sort by the 'Second field' of a dynamic value list (first field is a (UUID) primary key) when it is used on a report (list) layout. Is that possible?


In the second last column of the below report layout, a script sorting by 'Assigned to', sorts correctly by the 'First field' of the value list (shown temporarily in magenta) which I understand. But I'd like the sort to be according to the Names, which is the 'Second field' of the value list (shown as a pop-up menu).

Screen Shot 2018-04-29 at 13.27.45.png


The relationship between the Job and the Talent tables are:

Screen Shot 2018-04-29 at 12.53.26.png


The dynamic value list is set up as:

Screen Shot 2018-04-29 at 12.55.57.png


The script that runs on LayoutEnter:

Screen Shot 2018-04-29 at 12.57.11.png


It seems to me that line five is deficient, because it points to a Job table field that contains primary (UUID) keys on the Job table , and what I am wanting to sort to is the TalentAccountName on the Talent Table.