Teachers of multiple schools

Within our MAT we have a number of schools each with their own MIS/SIS. For teachers that teach across more than one school, they'll therefore have more than one MIS/SIS staff record and hence more t...