AnsweredAssumed Answered

Sorting calculation fields in a portal

Question asked by JohnCarpmael on Feb 14, 2014
Latest reply on Feb 16, 2014 by philmodjunk


Sorting calculation fields in a portal


     I am finding that while the portal sort works fine when it is first displayed, it does not re-sort when a value is changed.

     I have three tables, Table A, Table B and a join table that links A and B using unique identifier codes. In the join table I have two calculation fields which link to two fields in Table B: a text field containing a name and a numerical field containing a sort code. I have a portal in the Table A layout which is sorted by the two calculation fields - the sort code in descending order and the name field in ascending order.

     As I say it sorts fine at first but if I go into the portal and change the value of the sort code - the portal displays the values from Table B - the portal does not re-sort based on the changed sort code.

     Is this how FileMaker 12 works or am I missing something here ?

     I am working on Mac. And I have tried setting the sort either the relationship or in the portal itself.

     Many thanks for any help !