Replace all drop down list selections
I have a table of students in a martial arts school. Each record contains a drop down list with all the different colour belts. After each promotion test, every promoted student moves on to the next belt.
Is there a way to change every record at once so that the colour belt field shows the next option on the list? If this involves a calculation, will I have to assign a number value to each colour belt in the list?