Simple(?) calculation query

Discussion created by JulianJohnson on Dec 13, 2016
Latest reply on Dec 13, 2016 by David Moyer

Hi All,


I need to do what I'm sure should be a really straightforward calculation and am having a total brain freeze.


I need to return a carriage delimited list with the same number of lines as I have related records.


So I have a calculated field in my parent table and just say there are three related records in a child table, I just need to return the value of a different field in the parent table three times on separate lines as my result.


I have the List() function, I was hoping I could do with Substitute but don't have a reliable field value to substitute from (unless I just put in a calc always returning the same value). I'm sure there's a way more elegant way to do it!


I'm so sure it's simple but I'm having a complete blank!


Thanks in advance.


Kind Regards