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)

I have the same question (0)

All responses (5)

Answers (3)

Verified answer

nmaenpaa 101,160 Moderator on at

Like (0)

Report

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.

Was this reply helpful? Yes No
Verified answer

WillWU 22,361 on at

Like (1)

Report

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

Was this reply helpful? Yes No
Michael Antony 314 on at

Like (0)

Report

Hi Nikolaos, thank you for your advice.

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

Was this reply helpful? Yes No
Verified answer

Martin Dráb 237,884 Most Valuable Professional on at

Like (0)

Report

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.

Was this reply helpful? Yes No
Michael Antony 314 on at

Like (1)

Report

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.

Was this reply helpful? Yes No