How to make calculation that returns result from multiple records
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.