What I'm trying to do seems simple enough, but I cannot figure a way to do it.
I have a parent table (School Assignments) which is associated to a child table (Employments). In addition, the School Assignments table is a child table of the Schools table. Therefore, School-->School Assignments --> Employments.
The Schools table is also linked to a child table separately called Certificates.
Ideally, I'd like to show on the School Assignments record any Certificate records where the Certificate Start/End date is between the Employment Start/End dates. Currently, I can bring a report onto the School Assignments table that lists all Certificates but is there a way to show only ones that meet the criteria in both Employment and Certificate tables??