AnsweredAssumed Answered

How to make calculation that returns result from multiple records

Question asked by TomWickersham on Mar 8, 2012
Latest reply on Mar 15, 2012 by philmodjunk

Title

How to make calculation that returns result from multiple records

Post

Hello,

I have two tables, PEOPLE and HOUSEHOLDS.  I would like to create a calcuation that returns a result of the parents' names.  So, if there is only one parent record in the PEOPLE table, the result would be "Nancy Smith."  But if I have two related records (two parents records, but related in that they are both part of the same HOUSEHOLD), the result would read "Jane Doe and Wiliam Small."  Any help would be much appreciated.

BTW, I'm using FM Pro 7.

Thank you,

Tom

Outcomes