1 Reply Latest reply on Mar 25, 2016 1:45 PM by keywords

    I'm new to FileMaker. I have a many-to-many relationship between Client and Job tables. I want the link portal to be sorted by Job Name on the Client layout and vice versa. I tried to put a Job Name Calculated field on the link table which gets the Job Na

    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?