Select linked value from another field

[Anonymous]

Dears

Im using a input box to select multiple item no. in teh app.

I set a variabel vSearchItem and set variabel trigger action to trim the Item no.

='(' & Replace(Replace(Replace(Trim('$(vSearchItem)'), '  ', '|'),' ', '|'), chr(10), '|') & ')'

This works nicely

Now i would go one step further and selecte values from another field. In this case i would like to get selected the %Subassambly instead of the %Item field values.

dim_tabel is

%Item, %Subassembly

Item1, Sub1

Item2, Sub1

Item3, Sub2

Item4, Sub3

the logic should be, if somebody will paste Item1 and Item3 in the input box, the selection should be Sub1 and Sub2.

thansk for help  

Rgs

[Anonymous]

Since my knowledge is still very basic, its better to add functions which i understand, especially if i need to dig into, in some couples of weeks. Just like to keep the things simple for now... Im pretty sure that your solution might be the better one, as everything is done in one step... I have stored your sample and will review it for sure, once i have gained some more expericance

Thanks for all the feedback on this topic

Cheers Rob