show excluded values in alternate list box

[#1]

Hi Friends,

I have a scenario ,

     list box contactname is with alternate state group1 when i made selections excluded order id should shown in another list box with alternate state group2.

[NickHoff]

Use an expression for the listbox like:

=aggr(only({1-$}ContactName),ContactName)

or change ContactName ot Order_ID

[#3]

its not working ,

logic is)

1)select a contactname,

2)Orderid is field contains related and excluded ,i want excluded values as new list box,

3)Contactname group1 alternate state, and orderid is group2 alternate state

[NickHoff]

Okay, that is because they are alternate states, instead of the $ in the excluded orderID's replace that with your alternate state name, and change

=aggr(only({1-AlternateStateName}OrderID),ContactName)