I have setup Drop Down global fields with a relationship to a larger table to create a layout that filters portal results of that main table using the Drop Down field as filters.
I have run into the problem of not being able to initially see all the possible results in the table. I have 3 Drop Down fields (Region, Category, Specialty) and sometimes I would like to see New York Region but ALL Categories and ALL Specialties. I can see NY with 1 Category and 1 Specialty. But I cannot figure out how to create a value item that is all of the rest of the list combined (if that makes sense). There has got to be a way to do this.