Exclude items from picklist

Exclude items from picklist

Using the help center I was able to create a dynamic picklist that I am very happy with (and proud of )./

Well, now I want to take it a step further.

As it stands the dynamic picklist will display cities based on the selected state.  I want to be able to exclude certain cities.

This is used to manage our company locations.

I created a drop-down field named "Active?" with the choices "Yes" and "No".  I want any record marked "No" to be excluded from the list.  How can I do that?