AnsweredAssumed Answered

Calc field that is list of related records

Question asked by mmccarty on May 13, 2014
Latest reply on May 13, 2014 by philmodjunk

Title

Calc field that is list of related records

Post

     Hello,

     I have records in table A that have multiple attributes housed in Table B.  They are connected through a line item table, LI_AB.  I want to create a calculation field in Table A that is a list of all attributes.  For example record a1 has three attributes from table B.  I want the calculation field to be "b1,b2,b3". 

     I know that a portal will show me all of a1's attributes but the list will look better on my report.  I think I did something similar a few years ago using a custom function.  Unfortunately, I no longer have access to FM Pro Advanced (only FM Pro) aka no custom functions.

     Any ideas how to write this calculation?

Outcomes