How to select a value from a inline table based on name

[#1]

Hi Guys,

Has anyone come across the following issue,

I have an Input Box  in which user selects a  name and presses a button.

I have table which has 2 cols name,value.

When user selects name and presses the button then i want to display the value in a text box.

eg Input Box has values Employee Code,Dept Code etc populated from an inline table

     Value for the above names will be empcode,deptcode etc populated using the same inline table

Now when user selects Employee Code then I want to display empcode from inline table based on the text.

Regards,

Sabarish

[#2 · Accepted solution]

Input boxes are tied to variables. Add an 'On Input'  trigger to the variable (see Document Properties>Triggers) so that a 'Selection/Select in field' action will set the value in the field table.

Regards,

Gordon

[#3]

Also To select values from table i used

=Concat(Name,',')