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

Like (0)

Report
Copy link

Link copied!

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,363 on at

Like (1)

Report
Copy link

Link copied!

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
Copy link

Link copied!

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 239,038 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

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
Copy link

Link copied!

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