Fetching multiple values in listbox.

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

Hi,

I have a senario where i want to select all selected values from field A in field B. I have to display these two fields in listboxes.

There are 2 tables T1,T2. T1 has a field A and T2 has field B. Both fields are same but field B has less number of records than A.

E.g.

A has values : 2,3,4,7,12,13,15,34,37,98.

B has values : 4,7,34,98.

I want it as if i select 4,34,98 from B it should show the same selection in A also.

I am using a field event trigger on A as getfieldselection(B). this is working for a single value selection but for multiple value its failing.

please help.

Thanks,

Stabdha

Re: Fetching multiple values in listbox.

sunny_talwar — Wed, 17 Aug 2016 08:18:18 GMT

May be trigger like this:

'(' & GetFieldSelection(B, Chr(34) & '|' & Chr(34)) & ')'

Anonymous — Wed, 17 Aug 2016 08:36:12 GMT

Thanks Sunny for the quick reply.