Create 2 values based on a list of values

[dudumoscona]

Hi all,

i have a field that contains "leaving data" - if the employee left or fired and the reason.

left starts with V and Fired start with I .

Example V - Employee found a better place

                    I - Employee didnt do his job

i want to create a list box that will show only 2 values of "Fired" and "left" out of all the 100 reasons and also to show the Fired/left in the table i've built - is it possible?

[dudumoscona]

added 1 as test2 , was not added 😞

[tresesco]

That probably means that the same table is being dropped somewhere in the script. Or, the table is being referenced somewhere and there you need to mention new field (where it is finally being loaded).

[dudumoscona]

you correct but now i've added it and can see it however the choose list contain all the list of fields and not the values of this field

[dudumoscona]

[tresesco]

Now don't have to write expression for list box. You can simply refer field in list box rather than expression.

[dudumoscona]

the values in the list box are the fields in the script and not the rasons thats what i meant.. thats weird..