AnsweredAssumed Answered

Compare records in related tables

Question asked by SchoolData on Oct 9, 2014
Latest reply on Oct 12, 2014 by FentonJones

Title

Compare records in related tables

Post

The relationship graphic is attached.

The desired result is to input data from the school district’s database and the ADE databases to determine if teachers are properly licensed for the courses they are teaching.

I believe that a solution can be created in which for each record in Course «» Person the required Licenses to teach that course can be compared with the match records from Person «» License to determine if there is a match.

Screen_Shot_2014-10-10_at_6.26.31_PM.png

Outcomes