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

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :
Microsoft Dynamics AX (Archived)

Help explain Extended Data Types

(0) ShareShare
ReportReport
Posted on by 6,609

Hi everyone. As I'm getting more familiar with AX in general, I'm trying to get my head around certain concepts that I don't quite fully understand. I get the concept but when I attempt to drill down in the AOT I get lost. So here's any example...

CustAccount <extends> CustVendAC <extends> ExternalAccount

When I bind the CustAccount EDT to a control, I get a dropdown with the customer name and account number. Great!!! But how does it work behind the scenes. I've read on the topic in books and online but nothing has a concrete walkthrough that explains and deconstructs EDTs.

As always, any help would be appreciated!

*This post is locked for comments

I have the same question (0)
  • Suggested answer
    Syed Zeeshan Haider Jafry Profile Picture
    725 on at

    Check the Relations of the EDT. When you click the + on the EDT you will find relations node.

    In AX 2012 there is also a new property on the EDT "Reference Table" where the referenced or linked of the table with the EDT can be set.

  • Suggested answer
    Community Member Profile Picture
    on at

    Hi,

    We can not explicitly see how it works because that behaviour is written in system classes that we can not access. Debugger won't allow you to enter super() on the lookup method.

    However, like Zeeshan said, it is based on the relation defined for the EDT.

    Notice that we can not define relations for EDTs anymore with AX 2012. Only legacy EDTs (which have a LegacyId value) have relations. Now all relations must be defined at table level.

    Regards,

  • bankk Profile Picture
    6,609 on at

    Thanks for the replies. I have seen the relations node but looking at it doesn't help a whole lot quite honestly. So if we take CustAccount as an example, CustAccount is related to CustTable.AccountNum. But where does it define that the customer name should be shown as part of this EDT? Along that same vein, can we add additional fields from the related table? Thanks in advance!

  • Andrew Xu Profile Picture
    3,877 on at

    KBANH,

    The fieds of drop down list are defined in the field group AutoLookup of that table. You also can create a form to show the fields you need. Just refer to the form CustTableLookup, it will be triggered when you are selecting customer when creating sales order.

  • bankk Profile Picture
    6,609 on at

    Andrew, thanks for the clarification. This approach doesn't work with all EDTs which populates a drop down, correct? I was looking at CustGroupId trying to see if the AutoLookup field group defines the values, which it didn't. Can you share how you make the determination of the values for an EDT? Thanks again.

  • Andrew Xu Profile Picture
    3,877 on at

    For CustGroupId in table CustGroup, the properties "TitleField1" and "TitleField2" define the fields in drop down list becasue the AutoLookUp is empty and no lookup form exists.

  • sureshch Profile Picture
    20 on at

    Please follow the below details for EDT Relations.

    When You create an EDT In ax and after adding the Table Reference with the related field into EDT.

    When you are using this EDT field in any of the form or table . The lookup sequence will be as below.

    First it look for the Look up form.

    Second it look for the AutoLookup group in the field groups.

    Third it will look for the Title fields.

    But the related field is the default field in all these cases.

    Thanks!

    Suresh 

  • Basheer17 Profile Picture
    2,720 on at

    Please refer community.dynamics.com/.../224521. Look for Andre's comment.

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

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

#1
Priya_K Profile Picture

Priya_K 4

#1
Martin Dráb Profile Picture

Martin Dráb 4 Most Valuable Professional

#3
Scott_itD Profile Picture

Scott_itD 2 Community Manager

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans