Below is a scaled down version for what I am needing.
Table A has two columns: Location_ Name, ITEM_ID
Table B has two columns: ID, Description
Relationship is 1 to many, respectively.
In my grid I want to concatenate all descriptions delimited by ',' and by each location into a single cell.
The output would be as follows:
Location Description
Westchester 12546,145879,15698,12583
Torrance 32145,3258,32458
Glendale 14785
Pasadena 14589,156478
Grid properties:
Table A has two columns: Location_ Name, ITEM_ID
Table B has two columns: ID, Description
Relationship is 1 to many, respectively.
In my grid I want to concatenate all descriptions delimited by ',' and by each location into a single cell.
The output would be as follows:
Location Description
Westchester 12546,145879,15698,12583
Torrance 32145,3258,32458
Glendale 14785
Pasadena 14589,156478
Grid properties:
AutoGenerateColumns
="False"
AllowFilteringByColumn="True"
AllowPaging="True"
AllowSorting="True"
Please advise how I can achieve this?
Thanks in advance.