Update textbox with selected value description

[#1]

Hello All,

I have a listbox containing codes.  I want to update a textbox with a long description of the code selected.  The long description is in one of my loaded tables.  For example if the user selects code ABCD, I want to retrieve "This is my long description" from my table and display in the textbox.  Can someone please help?

Thanks in advance.

[#2]

Hi,

If I understand ... you have a table with Code and Description like this:

Code | Description

A       | This is my description 1

B       | This is my description 2

C       | This is my description 3

D       | This is my description 4

E       | This is my description 5

and you have Codes values in a list box, well if you load codes values (of list box) in script editor and named with the same name field in table of descriptions you just need an expression like this (in your text object):

=Only(Code)

best regards.

[Anonymous]

Hey,

PFA..

Hope ths helps.

Regards,

Chinna

[jagan · Accepted solution]

Hi,

Try like this

If you always select one value the

=Only(Description)

If you have multiple then use

=Concat(Distinct Description, ', ')

Hope this helps you.

Regards,

Jagan.

[#5]

Hi,

Try to link description in new table & use it in testbox.

Rgds,

Dhanushka

[#6]

Thanks all!  Exactly what I needed