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

(0) Share

Report

Posted on by Michael Antony

314

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.

(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.

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.

(This is Dynamics365 EDT extension)

All responses (5)

Answers (3)

Michael Antony 314 on at

Like (1)

Report

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 232,942 Most Valuable Professional on at

Like (0)

Report

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 314 on at

Like (0)

Report

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 22,352 on at

Like (1)

Report

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 101,158 Moderator on at

Like (0)

Report

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.