Make a list box based on another list box selection in an alternate state

[tinkerz1]

  Hi,

I have 2 list boxes setup as alternate states, can I set up one of the list boxes to show only those countries selected in the other list box?

So if France and UK are the only selections made in list box ' A' the user can only select those from B, both list boxes have alternate states.

Thanks,

[sunny_talwar]

Something like this?

Used this expression for the State2 list box for Country

=Aggr(Only({State1}Country), Country)

[swuehl]

Try a field expression in your state B list box, like

=Aggr( Only({A} Country), Country)