Calc field that is list of related records
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?