AnsweredAssumed Answered

Replace lots of records at once

Question asked by garonson on May 29, 2014
Latest reply on Aug 22, 2016 by dsnider


Replace lots of records at once


     A field may have only one of two values (1 or 2).  Only one record in the table may contain a 1.  User changes a 2 to a 1.  How do I in a script sense that change and change all other records in that table to a 2?  Note a 1 is a yes and a 2 is a no.  Only one record (A user) can be a yes (be the system default user).  I must programmatically assure this.

     Now its time for the experts to suggest just how to do this.  Please help.