web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Finance | Project Operations, Human Resources, ... / Lookup by EDT Table Re...
Finance | Project Operations, Human Resources, ...
Suggested Answer

Lookup by EDT Table Reference

(0) ShareShare
ReportReport
Posted on by CU26120130-0 8
So I am planning to have a lookup using EDT table reference but not working . I want Course table as lookup in student table via EDT -CourseID
 
 
Step 1- Created master table - Course Table  that will be look up in another table -Student table 
 
1. Course Table with colomn - CourseID , CourseName 
 
Step 2 -Create EDT - CourseID EDT
 I created CourseID EDT then created Table reference to Course table with its field  
 
 
Step 3- Create Student table 
 I dragged and dropped CourseID EDT in field section that supposed be lookup in UI - This is not working -lookup not coming for this field 
 
Note - When I create normal relation in student table with course table then lookup come but it seems EDT table reference do not need relation in student table just EDT table reference should work ?
 
Please let me know how EDT table reference lookup work , 
 
Thanks 
Categories:
Dynamics 365 Finance
I have the same question (0)
  • Suggested answer
    Martin Dráb Profile Picture
    Martin Dráb 238,791 Most Valuable Professional on at
    Having a reference on the EDT isn't sufficient - you need a table relation. There used to be relations on both EDTs and tables, but it was a mess in some cases and therefore Microsoft decided (in AX 2012) to make a breaking change and abandon table relations. Table references do not work the same.
     
    When your EDT reference is done correctly, you'll get a lookup for outbound controls, and Visual Studio will offer you to create a table relation when you drag the EDT to a table. For example, this is how it looks like when using HcmWorkerRecId:
     
    Note that the default primary key of tables is the surrogate key, i.e. RecId, and you're supposed to use CourseId as a replacement ID rather then the primary/foreign key.

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

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Stars!

Congratulations to our 2025 Community Spotlights

Thanks to all of our 2025 Community Spotlight stars!

Congratulations to the February Top 10 Community Leaders

These are the community rock stars!

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 521 Super User 2026 Season 1

#2
Giorgio Bonacorsi Profile Picture

Giorgio Bonacorsi 438

#3
Adis Profile Picture

Adis 261 Super User 2026 Season 1

Last 30 days Overall leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP

Product updates

Dynamics 365 release plans