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

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics AX (Archived) / duplicate records on i...
Microsoft Dynamics AX (Archived)

duplicate records on inheritaed tables fails

(0) ShareShare
ReportReport
Posted on by Community Member

Hi

I want to duplicate records in my table. the table extends the EcoResInstanceValue table and the duplication fails with an error that a record in EcoResInstanceValue table already exists.

Can someone pls advice how to do the duplication?

Best regards

Chris

*This post is locked for comments

I have the same question (0)
  • Community Member Profile Picture
    Community Member on at

    Hi

    I am wondering as well thats why I ask here

  • André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 304,500 Super User 2026 Season 1 on at

    Hi Chris,

    What is the business scenario you are trying to solve? Why do you want to have duplicate records? What is your "my table"? Is it a custom table? If so, why is it extending the EcoResInstanceValue? I do think you have to change your design, but depends on what you are trying to achieve.

  • Community Member Profile Picture
    Community Member on at

    Hi

    first: Yes it is a custom table. we are a leasing company and use it for conditions and so on. Now the users want to copy an existing condition list with all its (attribute) values to then just adapt single values to match a new condition. Creating a new one from Scratch means to fill a lot of values and sometimes the conditions are just different in 1 or 2 values.

  • Community Member Profile Picture
    Community Member on at

    Are you trying to insert using X++?

  • Community Member Profile Picture
    Community Member on at

    I do a copy of my data with tblCopy.data(tbl) and do a tblCop.insert()

  • André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 304,500 Super User 2026 Season 1 on at

    Hi Chris,

    It would be better to duplicate the original table or do another re-design as you cannot change the index using table inheritance.

  • Community Member Profile Picture
    Community Member on at

    well I do not get this.

    basically when I create a new record in the derived Table I shoud be able to set the data in the base table as well. Shouldn't I?

  • André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 304,500 Super User 2026 Season 1 on at

    Your question is about allowing duplicates in an existing table. This is a bad design choice. You have to solve the business requirement different. I cannot help as I don't understand what is required in detail.

    Note that on SQL server, the inherited table does not exists; they are new columns on the primary table.

  • Community Member Profile Picture
    Community Member on at

    oh no. I think there is a misunderstanding.

    When I duplicate the data in the derived Table I set a diffenrent value for the key so it is unique question is why the base table tells that the record exists

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

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Stars!

Meet the Microsoft Dynamics 365 Contact Center Champions

We are thrilled to have these Champions in our Community!

Congratulations to the March Top 10 Community Leaders

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

#1
CP04-islander Profile Picture

CP04-islander 39

#2
Michel ROY Profile Picture

Michel ROY 14

#3
imran ul haq Profile Picture

imran ul haq 8

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans