3 Replies Latest reply on Mar 19, 2013 9:19 AM by Oliver_Reid

    How to get the value from a 1-to-many related table in FileMaker 12

    liyangao

      I have a one-to-many relationship. I want to create a calculated variable in the main table (one side) and get the value from the related subtable (many side) . Since it is 1-to-many, one record in the main table is corresponding to several records in the subtable (many side). I can show all the related records in a portal. My problem is how to get hold of the field values that can be shown in the portal using a FileMaker function and do calculations based on these fields from the subtable.

       

      Thank you for your response,

      Liyan