show only possible values in list box

[sateeshkumar]

I have a requirement that to show only possible values in list box based on selection of other list box.

for example:

List1,List2  are two fields.

on selecting any value in ListA, I need to show only possible(white background) Values.

I tried like this

=aggr(only({$<List2  = P(List2  )>}List2  ),List2  )

It is working but on any selecting list2, it is showing green values. I need to show green values along with grey values also.

Can any one help me to get this?

Thank you.

[senpradip007]

Check Hide Excluded option in general property.

[tresesco · Accepted solution]

May be a bit simpler, like:

=Aggr(Only({<List2>} List2), List2)

[sateeshkumar]

Thank you.. It is working properly..

But can you please explain its functionality(How it works).

[#5]

correct answer

[#6]

How should i add an alternate state to the expression above?

I want the 'study_level' alternate field to work for the the listbox site_num. I applied the following expression to the site listbox but it did not work.

=aggr(only({study_level <site_num= P(site_num)>}site_num),site_num)

[andydietler]

I don't think you even need the only.

=Aggr(List2, List2)

works.