Skip to main content

Notifications

Microsoft Dynamics AX (Archived)

Auto lookup using EDT with Table reference

Posted on by Microsoft Employee

I'm having trouble getting an auto lookup to work with a new EDT without adding a specific lookup form.  The older EDTs (which have the table relationship defined in the Relations node) seem to work by either having some fields in the related table under the auto lookup field group, or having field names filled in for TitleField1 and TitleField2 (also on the related table).  By "working", I mean I get a dropdown automatically when I open the table in the AOT.

I'm trying to add a column to a table which has a new extended data type.  edt.JPG

Here's the EDT:

(reference table is Table123, Table Reference is EDT123 == Table123.mycode

related.JPG

And the related/reference table

mymaintest.JPG

table123.JPG

When I open my MyMainTestTable in the AOT, I expected to see a dropdown for field 3, but I don't.

mymaintest.JPG

What am I missing/doing wrong????

*This post is locked for comments

  • Suggested answer
    Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Auto lookup using EDT with Table reference

    You should create a foreign key relation in table node for getting the drop down.

  • Basheer17 Profile Picture
    Basheer17 2,720 on at
    RE: Auto lookup using EDT with Table reference

    Lookup will look at the fields in the 'AutoLookup' FieldGroup .

    When there are no fields in AutoLookup group, it will use the fields specified in the table properties TitleField1 and TitleField2 and the fields in the first unique index.

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Auto lookup using EDT with Table reference

    better.. thank you!

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Auto lookup using EDT with Table reference

    try this:

    axwonders.blogspot.com/.../working-with-ax-2012-edt-relation.html

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Auto lookup using EDT with Table reference

    Hi Tatiana:

    I did found that blog, but unfortunately none of the screen shots show up so its not very useful :(

  • Mea_ Profile Picture
    Mea_ 60,278 on at
    RE: Auto lookup using EDT with Table reference

    Hi amycww,

    Maybe this blog can help you blogs.msdn.microsoft.com/.../referencetable-table-references-on-edt it explains the difference between ReferenceTable and Table References in details.

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Auto lookup using EDT with Table reference

    you need to add the relation in the EDT like the SalesId, in older version (AX2009) this was very easy to do it, but not you need to change more than only add: dynamics-ax.blogspot.com/.../ax-2012-understanding-changes-to-table.html

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Auto lookup using EDT with Table reference

    I don't see a place to add a relation in a new EDT.  Here are the two I created... 456 is a "duplicate" of one of the

    old ones.  456 works, 123 doesn't

    6518.c4.JPG

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Auto lookup using EDT with Table reference

    No, I hadn't!  But I just added one and unfortunately it didn't do the trick.  I duplicated one of the "old style" EDTs and changed the reference and that worked just fine.  Guess I could go that route if I have to, but it seems like I should be able to make this work.

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Auto lookup using EDT with Table reference

    do you add the relation?

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

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Community AMA December 12th

Join us as we continue to demystify the Dynamics 365 Contact Center

New! Quick response templatesâš¡

Save time with the new custom templates!

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,151 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 229,993 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans