3 Replies Latest reply on Jan 16, 2010 6:21 PM by comment_1

    Listing related records in text calculation field

    daveslc

      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