Skip to main content

Notifications

Announcements

No record found.

Dynamics 365 Community / Forums / Finance forum / How to add relation to...
Finance forum
Answered

How to add relation to table on EDT in Dynamics 365?

Posted on by 312

Hi Expert! Greeting!

So, I want to add an EDT relation on the LedgerJournalNameId that is linked to the LedgerJournalName table on D365, like the one in AX2012.

pastedimage1627975216171v1.png

(This is AX2012 EDT relationship)

What I want to achieve is to get the same feature as AX2012, which is a dropdown option when selecting Journal Name.

pastedimage1627975347609v2.png

But unfortunately on D365 the relation from EDT to that table no longer exists, and I can't add it via extension either.
How to add this feature, what should I do? Please give me advice my friend.

pastedimage1627977803491v3.png

(This is Dynamics365 EDT extension)

  • Michael Antony Profile Picture
    Michael Antony 312 on at
    RE: How to add relation to table on EDT in Dynamics 365?

    Not forget to mention, just for the record, I have to include the relation between the two tables in the main table.

    So that the dropdown selector can be shown in the UI of the main table form.

    Or I can create a lookup like Will Wu said.

  • Verified answer
    Martin Dráb Profile Picture
    Martin Dráb 225,783 Super User on at
    RE: How to add relation to table on EDT in Dynamics 365?

    The option to add table relations on EDTs was removed already in AX 2012 - it was kept for EDTs created in previous versions, but you weren't allowed to add new ones.

    Note that table references on EDTs are available in both AX 2012 and D365FO.

  • Michael Antony Profile Picture
    Michael Antony 312 on at
    RE: How to add relation to table on EDT in Dynamics 365?

    Hi Nikolaos, thank you for your advice.

    Okay I think, I will try to develop a lookup to achieve this.

  • Verified answer
    WillWU Profile Picture
    WillWU 22,344 on at
    RE: How to add relation to table on EDT in Dynamics 365?

    Hi Michael,

    As Nikolaos said, relationship on EDT has been removed inD365FO.

    You should write codes to create a lookup control now, please check the blog:

    msdynamics.nevoitech.com/.../

  • Verified answer
    nmaenpaa Profile Picture
    nmaenpaa 101,148 on at
    RE: How to add relation to table on EDT in Dynamics 365?

    EDT extensions are a legacy feature, and you can't add such relations in D365.

    Depending on your scenario, you should either use table relations, or develop x++ lookup to achieve your goal.

Helpful resources

Quick Links

Replay now available! Dynamics 365 Community Call (CRM Edition)

Catch up on the first D365 Community Call held on 7/10

Community Spotlight of the Month

Kudos to Saurav Dhyani!

Congratulations to the June Top 10 community leaders!

These stars go above and beyond . . .

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 288,459 Super User

#2
Martin Dráb Profile Picture

Martin Dráb 225,783 Super User

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans