Hay,
Here is a clean version of the current database.
It is no where near complete, but my issue is in the "student information" form.
Under the "office use" tab:
Swimming day = Fixed source, monday through friday.
Coach 1/2 = Dependant on day in Swimming day 1/2, from "coaches" table check...