Skip to main content
Dynamics 365 Community / Forums / Finance forum / Surrogate key relations
Finance forum
Suggested answer

Surrogate key relations

editSubscribe (0) ShareShare
ReportReport
Posted on by 362

Hi Team,

When creating a relations in D365 i found that we have nodes as Relation and ForeignKeyRelation. However in AX 2012 we can create a relation based on Surrogatekey to maintain the consistency of data. Could you please help me in knowing if we can create a relation through surrogatekey so that a new field will be created in childtable.

Regards

Venkat

  • Suggested answer
    Sheikh Sohail Profile Picture
    Sheikh Sohail 6,125 on at
    RE: Relations in D365

    Yes, You are right

  • Venkatdax0 Profile Picture
    Venkatdax0 362 on at
    RE: Relations in D365

    Hi Sohail,

    So if i need to create a relation through RecId of Parent to the RefRecId field in child table first i need to create a RefRecId field in child table and i need to create a normal relation.Is my understanding correct.

    Rg

    Venkat

  • Venkatdax0 Profile Picture
    Venkatdax0 362 on at
    RE: Relations in D365

    Hi Uday,

    Thanks a lot for sharing the link in which it details about the EDT Relation.However my query is related to the surrogate key based relation in D365.

    Regards

    Venkat

  • Suggested answer
    Sheikh Sohail Profile Picture
    Sheikh Sohail 6,125 on at
    RE: Relations in D365

    No, I D365FO You have create field manually then have to add Foreign Key Relation between tables.

  • Suggested answer
    udaY-ch Profile Picture
    udaY-ch 4,616 on at
    RE: Relations in D365

    Hi,

    community.dynamics.com/.../237621

    Best,

    Uday.

Helpful resources

Quick Links

What Motivates a Super User?

We know many of you visit the Dynamics 365 Community and Power Platform…

Demystifying Copilot with Georg Glantschnig…

Industry experts answer burning questions directly from our amazing Community…

Setting Up Knowledge Sources for Copilot…

Look at how configuring a comprehensive knowledge base is crucial…

Leaderboard

#1
Andre Arnaud de Calavon Profile Picture

Andre Arnaud de Cal... 283,066 Super User

#2
Martin Dráb Profile Picture

Martin Dráb 222,585 Super User

#3
nmaenpaa Profile Picture

nmaenpaa 101,138

Product updates

Dynamics 365 release plans