Array issue

[Scroller52]

Hi, i'm running CRXI Release 2 on a SQL DB.

This is what my data looks like. for every investor there are multiple contacts. using either the full name or the cc name field, i would like to display all of the contacts names like this 'C1, C2, C3 and C4'. i no i have to use variables and arrays of some sort, but i'm very weak with this stuff. my data is grouped by a 'type' and by 'investor' i would need the contacts to be displayed in the group header section. any help is greatly appreciated.


Investor_Name Contact_FullName Contacts - cc Name
Joe Smith C1 "C1
C2
C3
C4"
Joe Smith C2 "C1
C2
C3
C4"
Joe Smith C3 "C1
C2
C3
C4"
Joe Smith C4 "C1
C2
C3
C4"

 

[Scroller52]

column contact_fullname contains 1 of the contacts
contacts - cc name contains the entire list of contacts for each investor.