HT list related fields (self_join) in one single field

General support questions.
Posts: 5
Joined: Fri Aug 12, 2005 7:53 am
Location: Saint-Denis (La Reunion)
PostPosted: Wed Aug 17, 2005 1:05 am
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
Patrick Odelin
Anaesthesiologist
La Reunion Island (Indian Ocean)
GMT + 4
SeedCode Staff
SeedCode Staff
Posts: 2764
Joined: Thu Nov 20, 2003 11:01 am
PostPosted: Wed Aug 17, 2005 6:00 am
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.
John Sindelar
SeedCode
Posts: 5
Joined: Fri Aug 12, 2005 7:53 am
Location: Saint-Denis (La Reunion)
PostPosted: Wed Aug 17, 2005 6:09 am
Lot of thanks John :wink:

Patrick
Patrick Odelin
Anaesthesiologist
La Reunion Island (Indian Ocean)
GMT + 4

Return to General Support

Who is online

Users browsing this forum: No registered users and 3 guests

cron
(855) SEEDCODE
[email protected]
Follow us: