Display multiple values in text box based on list box

[#1]

Dear All,

Good Morning,

I am in to a situation where i need to show multiple values in text box.

here is the scenario:

I have two list box named, Person Id and Certification , what i want to do is select one value in person id and values from certification box should be shown in a text box, ''Certification field contains multiple values'', I can only select in person id field.

Issue is text box displays the values from certification filed when there is only one value, for multiple values it shows blank data.

Thanks

[marcus_sommer · Accepted solution]

Try it with concat() as textbox-expression maybe with an additionally condition like:

if(getselectedcount([Person Id]) = 1, concat(Certification, ', '), 'to many values - please select one Id')

- Marcus

[anbu1984]

=Concat(DISTINCT Certification,',')

[#4]

Thanks All

Solved!!!