1 Reply Latest reply on Mar 16, 2011 9:22 AM by philmodjunk

    Add a number to a field - update as a group

    PeterDowns

      Title

      Add a number to a field - update as a group

      Post

      Hi

      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.

      Cheers

      Downsy