how do we disply two different fields in One list box

[#1]

Hi Qv,

I have 2 different plantid and plant name fields .i want to display same values in single list box with -.

like

100-A

101-B

how we can do it??

Thanks

[MayilVahanan · Accepted solution]

Hi

Try like this

1.Script:

Load PlantId &'-'& PlantName as NewField, * from Tablename;

Then use NewField in listbox

2.Listbox:

Expression:

PlantId &'-'& PlantName