multiple records in a text box

[#1]

Hi,

I need to display multiple records from a field in a text box objext, i.e. multiple product codes.

Is there a function I can use for this e.g. concatenate function?

At the moment, if there is an attribute found for two product codes, only the first one displays.

Regards,

Gregg

[rustyfishbones]

Hi Gregg,

Did you try add a Text Object and try

=GetCurrentSelections([Product Code])

This will result in a Text Object saying

Product Code: A001, B001, C001 ETC.....

You can add SUBFIELD to it to clear Product Code:

=SUBFIELD(GetCurrentSelections([Product Code]),':',2)

result is A001, B001, C001

Does that help

Regards

Alan

[#3 · Accepted solution]

Hi Al,

I got this working using the concatenation function.

The user enters in different criteria so if there are multiple records found, I use the concatenation distinct function to effectively list them all out.

Regards,

Gregg