web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Small and medium business | Business Central, N... / How to get the Unique ...
Small and medium business | Business Central, N...
Suggested Answer

How to get the Unique primary key with each record..

(0) ShareShare
ReportReport
Posted on by Govinda Kumar 2,304 Moderator

Let's say I have a table with multiple fields and I want to add multiple duplicate records. But I cannot use any working field of my table as the primary key.. instead, I want to use a key that will automatically be generated every time I add a record so that I would have multiple duplicate records.

Just like we have a RecId in other ERPs like FinOps.

Thanks

I have the same question (0)
  • Suggested answer
    DAnny3211 Profile Picture
    DAnny3211 11,397 on at

    Hi

    you must create a field of this type

    pastedimage1668798599222v1.png

    check my answer if it helped you, thanks

    DANiele

  • Suggested answer
    Inge M. Bruvik Profile Picture
    Inge M. Bruvik 1,111 Moderator on at

    And you will also have to define the new field as the primary key on your table and that can be a challenge if you already have data in your table.

    So one option could be to create a new table withe the EntryNo as PK and then migrate your old data to your new table.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Small and medium business | Business Central, NAV, RMS

#1
OussamaSabbouh Profile Picture

OussamaSabbouh 2,238

#2
YUN ZHU Profile Picture

YUN ZHU 773 Super User 2025 Season 2

#3
Sumit Singh Profile Picture

Sumit Singh 630

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans