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


Listing related records in text calculation field


I have a one to many relationship with two tables:


  event name 






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,; Joe,


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.