I have two dropdown queries and the main query. One is for Commands, there are only two A and B with FCRLAS_ID's of 1010004 and 1010005. Or they can select all and the following dropdown will show all facilities. But if they select a command, then there is a short list of *-All Facilities. Then the main query would show results based on the facility selected or all facilities that have the short list of facilities as their supervising facility. I'm attaching a short query I'm working with to try and get the dropdown for the facilities to show me the list of the *-All Facilities. So, right now, if I select a command I get no results on my main query. I'm also attaching a list of the results I get when I don't try to pick 1 command. I get a list of everything for both commands.