Autonumber not Detecting Duplicates - Bug? Topic is solved

[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

[kev1n]

Hi Paul,

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

[pmjd]

Thanks kev1n