AnsweredAssumed Answered

Changing auto-enter characteristics in a script

Question asked by DonWalker on Aug 28, 2011
Latest reply on Aug 29, 2011 by DonWalker

Title

Changing auto-enter characteristics in a script

Post

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?

 

thanks,

Don

Outcomes