T
Thomas Mercer-Hursh
Guest
If you define the fields as mandatory and/or provide them with a non-null default value, you won't have the problem. I know I was initially surprised by this behavior when I first discovered it ... maybe 30 years ago 
... but there are circumstances where it can be desirable behavior. An example being when a field is not known at the time that the record is created. One may want the index to be unique once the value is known, but the value may only be determined later.
Continue reading...
... but there are circumstances where it can be desirable behavior. An example being when a field is not known at the time that the record is created. One may want the index to be unique once the value is known, but the value may only be determined later.Continue reading...