Select excluded values in a listbox based on selection in other listbox

[kinjal1645]

Hi,

When I select value in ListBox1, I want similar value/s to be selected in ListBox2.

Currently, value in listbox2 are getting excluded and I want to force selections between. Tried it with trigger, but did not help.

Can someone tell me how can I do it with set analyis or any other way.

Current situation:

ListBox1

Test1.2

Test2.3

Test3.2

Test4.3

ListBox2

Test1.1

Test2.2

Test3.1

Test4.2

Test5.5

Test3.3

Expected: example - Test3.2 should select Test3.1/Test3.3

ListBox1

Test1.2

Test2.3

Test3.2

Test4.3

ListBox2

Test1.1

Test2.2

Test3.1

Test4.2

Test5.5

Test3.3

And it should work other way, selecting Test3.1/Test3.3 should auto-select Test3.2 too.

Kindly help!

Thanks

[settu_periasamy]

How these two fields are associated? Same table?

Did you try with alternate state?

[MarcoWedel]

Why would you like excluded values to be selected?

Can you describe the expected behaviour of your application?

[kinjal1645]

They are in different table associated with common column.

[settu_periasamy]

If it is related, it will automatically display. If you want to do it in force, you need to do the trigger with select in field(Listbox2) , search string should be =left(Listbox1, 5)&'*'

And clear the Listbox1

[kinjal1645]

I has already tried it with trigger but values are excluded so it did not work. It is working for values that are not excluded with trigger.

Do you know how to do it with 'if' statement or set analysis?