Setting a filter on a picklist is a really easy way to dynamically filter results, as other picklists are chosen.

I have a number of criteria picklists which narrow the search results of a final picklist.

I have the following

Status = Active

Activity_Type

Location

Site_Name

Equipment (Which contains the list of equipment, which have the above 4 criteria)

So my filter looks like:

values  =  Equipment_Record[(((Status == "Active" && Sites.Site_Name == input.Site_Old) && Activity_Type == input.Activity_Type) && Locations == input.Location)].Equipment

Ideally I would like the items in the picklist only appear when all the criteria are selected. What I would rather is that the list is filtered as the selections are picked, rather then at the end. So for example, if I just select two of the filtering criteria, the equipment list shows all the possibilities that match.