In my database, the key of the transition among the academic years is AcadimicYear table which include information about the academic unique ID, year name, start date and end date. To prepare my database to the next year, I need the AcadimicYear table move to the next year (record) automatically so that a new information about the new year is entered , also make that year valid for the whole database forms. Any idea to achieve this goal please?