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
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.
#1
Sohail Ahmed
2,655
#2
Mansi Soni
1,574
#3
YUN ZHU
1,453
Super User 2025 Season 1
Share
Report
All responses (
Answers (
