AnsweredAssumed Answered

Replace lots of records at once

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

Title

Replace lots of records at once

Post

     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.

Outcomes