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.