2 Replies Latest reply on Sep 27, 2010 10:09 AM by jonasg

    Loop through related records in Calculation field

    jonasg

      Title

      Loop through related records in Calculation field

      Post

      Hi,

      Using FM11, I have 2 tables:

      contacts(ID, first_name, last_name, c_combined_name)

      contactDetails(contactID, content_type, content)

      which allows to add arbitrary contact information, such as phone numbers, email, address, birthday, ... without cluttering the screen with lots of unused, pre-defined fields. The problem:

      I have a portal showing only the names of contacts (c_combined_name). I would like to display all the contact details within the field's tooltip, separated by linebreaks.

      Is there a way to loop through all the contact's related records within a calculation ( aside from using a custom function + recursion) ?