5 Replies Latest reply on Feb 16, 2014 7:33 AM by philmodjunk

    Sorting calculation fields in a portal



      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 !