How do I change categories on a yearly basis?
I am working to improve our academic department's database. The department has established a contact list which includes it's current students among other categories of contacts. Among other improvements, I'd like to create is a means by which our contact's categories are updated automatically, such that when a 4th-year student finishes their last term, their status changes to "alum".
Perhaps it should begin with a prompt, giving me the option to waive the change, on occasions when I know the student to not meet the criteria for the change.
Can this be done? How would you approach the problem?