AnsweredAssumed Answered

Listing related records in text calculation field

Question asked by daveslc on Jan 16, 2010
Latest reply on Jan 16, 2010 by comment_1

Title

Listing related records in text calculation field

Post

I have a one to many relationship with two tables:

  Events

  event name 

 

Contacts

  name

  email 

 

I need to use a calculation field from events to list related contact information in text format:

 

E.g. the output should be something like:

event name, contact::name, contact::email   (e.g. Birthday Party, Bill, bill@bill.com; Joe, joe@joe.com).

 

where contact::name and contact::email might be repeated several times based on how many related records there are.

 

list() is close to what I need, but it outputs results with carraige returns.  I need the outputted results to have ',' or ';' as field and record separators if possible. 

 

thanks,

Dave

 

 

Outcomes