Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
Fantastic! That does exactly what I need. Thanks a lot Rajni!