Add a number to a field - update as a group
I have a table with a year field containing
7, 8, 9, 10, 11, 12
I need to rollover these numbers at the end of the year and add 1
so they would become
8, 9, 10, 11, 12, 13
Created a setfield script
Set Field [finance::year; finance::year +1]
Button is located on the layout page where the data is.
It works fine but only updates one record at a time. I need it to update all the records at once. Any advice would be appreciated.