AnsweredAssumed Answered

Need to combine variable number of fields into one

Question asked by ChrisWilson on Nov 29, 2014
Latest reply on Dec 2, 2014 by philmodjunk

Title

Need to combine variable number of fields into one

Post

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?

Outcomes