Skip to main content

Notifications

Dynamics 365 Community / Forums / Finance forum / Surrogate key relations
Finance forum

Surrogate key relations

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,624 on at
    RE: Relations in D365

    Hi,

    community.dynamics.com/.../237621

    Best,

    Uday.

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

November Spotlight Star - Khushbu Rajvi

Congratulations to a top community star!

Forum Structure Changes Coming on 11/8!

In our never-ending quest to help the Dynamics 365 Community members get answers faster …

Dynamics 365 Community Platform update – Oct 28

Welcome to the next edition of the Community Platform Update. This is a status …

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,240 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,149 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans