Display all values in textbox for particular selection

[harleen_singh]

Hi,

I have data like this

Citi Bank  Anuj

Citi Bank  Abhishek

Hdfc Bank  Radha

Hdfc Bank  Raj

i want to display values in Text box like this Anuj, Abhishek when Citi bank is selected

and

Radha, Raj when HDFC bank is selected.

Also, i need to show this output in Expression in straight table to give following output

Hdfc Bank  Radha,Raj

Citi Bank     Anuj, Abhishek

Thanks

Harleen

[vinieme12 · Accepted solution]

concat (DISTINCT Names,',')

[harleen_singh]

thanks Vineeth