4 Replies Latest reply on Mar 26, 2016 4:33 AM by erolst

    Sorting portals based on many-to-many records

    peter.martin@sinclairdesign.com.au

      i'm new to FileMaker. I have a many-to-many relationship between Client and Job records. I wish to list these links by Job Name in a Client layout portal and vice versa on the Job layout. I put a calculated field - Job Name Calculated - on the link record, which works when I view this table's records. However, when I use this field to sort the portal, it does not sort correctly. Is there a step I'm missing?