calculation to combine related text records
Sorry for my inexperience, I imagine this is a simple problem that's been answered before, but I've searched without luck...
I'd like to create a field which combines related text records. The particular use I'm trying to make work is:
Three book titles may be on the same contract. I display all three in a portal, of course, but would like to create a "contract title" field which displays all three titles in one field. For example:
Record 1: A Song of Ice and Fire
Record 2: A Clash of Kings
Record 3: A Storm of Swords
...would display as:
Contract Title: "A Song of Ice and Fire, A Clash of Kings, A Storm of Swords"
Thanks for any help,
"Contract Title: \" " & Substitute(List(relationship::Title);"¶";", ")) & "\""