Advance to next value in list
Hello all new to FM and this forum. I know this is relatively easy (I think?), but I can't find the fix, and I've googled until my fingers bleed but still can't seem to find a solution (my terminology may be off?). Anyway I have a value list (text) which I use to populate a Field One. I have a second field (Field Two) that needs to calculate (thus display) the next value in the list. Ex:
Value list = Red, Green, Orange, Blue, Black
Field One (user has selected Green from dropdown list) = Green
Field Two (needs to calculate next value in list) = Orange
Any/all help appreciated.