I have a table occurence based on Discipline. When I enter the layout, it shows only the matching disciplines. I then constrain the set to find a "Status." It's fine up to here. I only see Disciplines (which is Automotive) with the chosen status (Production).
What I'd like to do next is find all records with the chosen discipline, ignoring status, and find a date range. When I use "Extend Found Set" and enter the date "3/1/2016..3/15/2016" I am seeing records that are outside the Discipline. Any idea what I'm doing wrong? I can't understand why records that don't match the relationship of the TO show up in the layout.