Need to combine variable number of fields into one
I'm guessing this is an easy issue, but I'm not finding an answer so I thought I would see if someone can help me out. I am creating reports that need to list the names and ages of children of a given parent. The children's names and ages are contained in a related table, using the parent's unique ID. I can build the calculation to tell FMP to compile the names and ages of the children, but I don't know how to tell it to stop when it finds the first blank field (meaning if there are only two kids in the family, how do I tell the calculation to stop when it reaches the field for child3 and it's empty). Any thoughts?