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.