Page 1 of 1

HT list related fields (self_join) in one single field

PostPosted: Wed Aug 17, 2005 1:05 am
by podelin
Hi !

I have:
- a classical Society / Contact system,
- a self join, in the contact OT, on fk_society_id = fk_society_id,
- one contact layout with a portal wich displays all the contacts existing in the society of the current contact record.

Question: Is it possible to list all those contacts (from the portal) in one another single field (list with carriage returns) on the same layout ?

Subsidiary, if possible, how to :wink:

I hope this sound clear ....

Thanks in advance

Patrick Odelin

PostPosted: Wed Aug 17, 2005 6:00 am
by John Sindelar
Sure. You can build a value list using the portal's relationship and the contacts' names you'd like to see. Then use ValueListItems() in a calc to display the related contents as a text string.

PostPosted: Wed Aug 17, 2005 6:09 am
by podelin
Lot of thanks John :wink:

Patrick