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,