AnsweredAssumed Answered

Replace all drop down list selections

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

Title

Replace all drop down list selections

Post

     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?

Outcomes