AnsweredAssumed Answered

Replace all drop down list selections

Question asked by notJames on May 20, 2014
Latest reply on May 23, 2014 by notJames


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?