Remove selected value from list box

[#1]

Hi All,

I got two list boxes which are not related.

ListboxA ListBoxB

A A1

B B1

C C1

When I choose A in listboxA ListBox B should display B1 and C1; Choosing B in LisboxA should have a display A1 and C1 in listboxB.

I make this work using macro. Is there any way to solve this without using macro?

Thanks,

Nadsky

[#2]

Did you already tried dome link table?

[#3]

Hi Ramunas,

Thanks for the response. Sorry but I don't know how to create a dome link table. .

I'm wondring if this can be solve by expressions?

Thanks

[Anonymous]

Nadsky,
It can be done using list box with expression:
=aggr(only({1-$} ListBoxB),ListBoxB)

[#5 · Accepted solution]

Hi,

You can use a "EDIT EXPRESSION" and filtering whith a function "LIKE"

See the example.

[#6]

Hi Eduardo,

Wow! you solutions works!

A big thanks to you!

Regards,

Nadsky