Changing auto-enter characteristics in a script
I have a database with a unique, auto-enter registration number. In order to prepare for a new year I have copied the current registration number into a field for "last years reg #".
I want to then blank out the current year reg # but if I set the field to "blank" nothing happens to the field. If I set the field to "zero" I violate the unique rule for the field.
Can I change the field "unique" characteristic to "non-unique" in a script, blank the field, and then set the field back to "unique."
Or is there an easier way to clear out the registration field for the new year?