How to filter one column based on another when creating a select field?

[Anonymous]

Hi Folks,

Say, I have a table like this:

COL1	Visible
1	yes
2	yes
3	no
4	no
5	yes

Normally I can create 2 fields: COL1 and Visible. COL1 shows all values (1,2,3,4,5) and Visible shows 'yes' and 'no'.

When I select 'yes' in 'Visible' manually, 1 2 5 will be white in COL1 and 3 4 will be greyed out.

But how can I create COL1 field with a condition so that it can by default show only 1 2 5 without having the user manually selecting 'yes'? (In this case I don't need to create the 'Visible' field at all)

Is it possible doing so without creating new tables?

I am aware there is a "conditional" checkbox in every field's Properties - Expressions tab. Is it the right place to look at? How to write the condition?

Thanks,

Jeremy

[rajni_batra · Accepted solution]

u wrote the expression in expression tab of  list box that's wrong use it in general tab of List Box (attached screenshot ) or create a Straight or pivot table & then wriite d same expression there inexpression tab.

Hope this Help

[Anonymous]

Fantastic! That does exactly what I need. Thanks a lot Rajni!