Page 1 of 1

Autonumber not Detecting Duplicates - Bug?

Posted: Wed Apr 06, 2022 5:43 pm
by pmjd
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

Re: Autonumber not Detecting Duplicates - Bug?

Posted: Wed Apr 06, 2022 6:25 pm
by kev1n
Hi Paul,

You're right. nuAutoNumber and "No Duplicates" are not compatible.

Re: Autonumber not Detecting Duplicates - Bug?

Posted: Thu Apr 07, 2022 4:48 pm
by pmjd
Thanks kev1n