I just want to see if I have this right before I go ahead and implement it:
If the table I'm using for the dropdown list contains a field called "Active", and I'm currently using the value in the field called "ClientName" for the list, I create a new field in the same table called "ClientNameList" (or whatever) with the calculation:
If ( include = "active"; Active ; ClientName )
And use the "ClientNameList" as the field on which I base the dropdown list?
If "Active" is the selected value entered in a field called "ClientName", it should look like this:
If (Include = "Active" ; ClientName ; "" )
(Last parameter: "" is added for clarity, you can leave it out)
Then your value list should use values from this new calculation field to get only those client names where "active" was selected in the include field.
What if you want to elliminate ALL but the ones that have the word "CLOSED"?
How do you write with the expression to exclude?