I am trying to filter records by a lookup field. I want all the records that contain that specific item, and only those items. However, because the filter options are only “contain,” “does not contain,” “is empty,” and “is not empty” AND because some of my items are contained with each other (“Technical Director” and “Assistant Technical Director”) I cannot filter the way I want to. For example, if I select “contains Technical Director” that pulls up records with both Technical Director and/or Assistant Technical Director. I can’t filter out “Assistant Technical Director” records because that
Wouldn’t it be fantastic if the filter terms for lookup records were the same as the filter terms for multiple choice? Then you’d have so much control!