Limit listbox values on existence in another field

[hugmarcel]

Hi

I have fields

- A with values 1, 2, 3, 4, 5, 6
- B with values 1, 2, 5

Now I want to create a listbox on field A showing values only that exist in field B.
Once a value in listbox is selected, all other values in B shall still be visible greyed out.

Any idea? Something like

aggr(only({$<=p({1} )>}),)

does not work as listbox formula.

Thx - Marcel

[hugmarcel]

aggr(only({$<=p({1} )>} A),)

is a better try... I missed the A as part of the only function.

[hugmarcel · Accepted solution]

aggr(only({1<=p({1} )>} A),)

Shows the hidden values greyed out as required.