tblSchools should have a
SchoolID field (autonumber primary key)

in tblContracts a field
SchoolIDLink type number

if using a form to enter contracts the form record source would be tblSchools add a subform with record source tblContracts
use SchoolID > SchoolIDLink being the relationship

Set this up in relationships too...

Hope this is detailed enough

Not sure I understand the question
Jim