Using only a found set in a value list

[John R]

I have field with multiple selections, one of which is "active". I set the find to find "active". I want the value list to only show the "active" members in the found set. Instead it shows all. What am I missing?

[Vaughan]

Create a calculation field, let's call it ActiveMembers:

If( Status = "active", MemberName, "" )

This calculation field will only display the member's name if the status is active. (I'm guessing here that you have a Status field where "active"s entered, and another field with the member's names.)

Create a new value list and base it on this calculation field.

[John R]

my thanks...