Concatenated column within table

[martynwb]

Hi all,

I need some help please.

I have three source tables: Asset, Component and Assessment. An asset is related to multiple components and an assessment is linked one a single asset. 

I've displayed a number of fields in the table from assessment and asset. I would like to add a column with all of the related components but I can't figure out how to do it. It's always displays as blank.

Any ideas would be greatly appreciated. I've attached a screenshot.

[Ksrinivasan]

hi,

any common field are available in both field?. supposed to be that common field should have value.

ksrinivasan

[martynwb]

The issue seems to be that there are common fields between asset and component and asset and assessment but not directly between assessment and asset. That is the linkage that I need to incorporate.

[Ksrinivasan]

hi,

pl, explain how you are going to link by manually that two tables,

ignore script, 

is there any Master type of third table required to join?

ksrinivasan.