I really appreciate you working with me.
Would it be too much to ask how you would create the two tables that are associated with schools, please?
For example, If in tbl_school id 1 is Memphis State 1996 and previous years, would id 1 change to Memphis for 1997-onward?