Multi Keyed Value Relationship

[James Gill]

I have created a field that contains a list of foreign keys separated by returns. What I want to do is create a calculated field that takes a value from each of the related records and combines them into a specific format within a record. So, for the field that contains the foreign keys, I have:

115¶

258¶

458¶

The Full Name field of foreign key record contains:

"Ronald Reagan"

"Bill Clinton"

"George Bush"

So:

115¶ - "Ronald Reagan"

258¶ - "Bill Clinton"

458¶ - "George Bush"

I want the calculated field to take the full name values and then output them like this:

"Ronald Reagan, Bill Clinton, George Bush"

The problem I have is that this relationship can have as few as 0 related records and potentially as many as 100 related records. How would I format calculated field to take this into account and not add a comma after the last value?

Edited June 10, 2010 by Guest

[bruceR]

Substitute( List( relation::namefield); "¶"; ", ")

[James Gill]

Well hey that was pretty easy. Thanks!