Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
May be trigger like this:
'(' & GetFieldSelection(B, Chr(34) & '|' & Chr(34)) & ')'
May be trigger like this:
'(' & GetFieldSelection(B, Chr(34) & '|' & Chr(34)) & ')'
Thanks Sunny for the quick reply.