Autonumber not Detecting Duplicates - Bug?
Posted: Wed Apr 06, 2022 5:43 pm
Hello,
I've used the autonumber field type and set it for No Duplicates, but when testing by resetting the autonumber field to an initial value it allows duplicate values to be created by new records.
Is this a bug, or should this be better dealt with in SQL, and use SQLto set a field with unique and auto_increment attirbutes?
Thanks,
Paul
I've used the autonumber field type and set it for No Duplicates, but when testing by resetting the autonumber field to an initial value it allows duplicate values to be created by new records.
Is this a bug, or should this be better dealt with in SQL, and use SQLto set a field with unique and auto_increment attirbutes?
Thanks,
Paul