In the teams table, this routine will:

• copy the NameThisYear and ConvenerThisYear to the NameLastYear and ConvenerLastYear columns for all teams
• change the NameThisYear column to reflect the Team Numbers until team names are chosen.

In the season table, this routine will

• copy the ThisYear data onto the LastYear data
• change the ThisYear data to reflect the new season

Make sure you have made a backup copy of the both the teams and season tables before proceeding.