AnsweredAssumed Answered

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

Question asked by liyangao on Mar 15, 2013
Latest reply on Mar 19, 2013 by Oliver_Reid

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,