I am looking to setup a CRM database that can track medical resident prospects and clients through the 4 or 5 years that they are in training. I need to have the system move the group members of Sample Hospital, Surgery Residency department from year 1 to year 2 on 5/31 of each year.....there are many programs with different graduation dates and some are 4 years, and some are 5. I also want the system to help me to move graduating members into other hospital groups upon completing training..