Loop through related records in Calculation field
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) ?