I have a situation where I have a single drop down list populating 2 different fields. It is used to allocate engineers to projects, and although the list of engineers is the same, they may be either Primary or Secondary on any particular project.
I want to create a filter for each engineer, showing only projects where they are either primary or secondary, but that requires OR logic. When I add the criteria for them to be P or S, it returns 0 records because it is looking for them in BOTH.
Is there any way to implement what I need?