What is the purpose of the AutoNumber primary name field? Since is not guaranteed to be unique, why else would you want to use it?
I appreciate the workaround, but really my question is why is there a duplicating autonumber feature in the first place. When would you want that? I guess that is just a sub question to the main question: What is the purpose of the primary name field, other than "the field you think is unique but if not no harm since all the joins are on the GUID, except there will be harm because you will end up with duplicate records with different GUIDS when importing records unless you have created alternate keys on the columns you thought were unique".
Hello @FerrDiBarnes
Please refer https://powerusers.microsoft.com/t5/Microsoft-Dataverse/Autonumber-isn-t-unique/td-p/1744606
Hope this was helpful
Hello,
There are a few techniques to guarantee the uniqueness of that field:
How do you make it read only? The field does not appear on any form.
Hi @FerrDiBarnes if you make the field read- only then it can be unique right.
Hope this was helpful
mmbr1606
22
Super User 2025 Season 1
stampcoin
19
Michael E. Gernaey
15
Super User 2025 Season 1