Auto lookup using EDT with Table reference

(0) Share

Report

Posted on by Community Member 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.

Here's the EDT:

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

And the related/reference table

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

What am I missing/doing wrong????

*This post is locked for comments

All responses (13)

Answers (0)

Suggested answer

Community Member Microsoft Employee on at

Like (0)

Report

RE: Auto lookup using EDT with Table reference

You should create a foreign key relation in table node for getting the drop down.
Basheer17 2,720 on at

Like (1)

Report

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 Microsoft Employee on at

Like (1)

Report

RE: Auto lookup using EDT with Table reference

better.. thank you!
Community Member Microsoft Employee on at

Like (0)

Report

RE: Auto lookup using EDT with Table reference

try this:

axwonders.blogspot.com/.../working-with-ax-2012-edt-relation.html
Community Member Microsoft Employee on at

Like (0)

Report

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_ 60,278 on at

Like (0)

Report

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 Microsoft Employee on at

Like (0)

Report

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 Microsoft Employee on at

Like (0)

Report

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
Community Member Microsoft Employee on at

Like (0)

Report

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 Microsoft Employee on at

Like (0)

Report

RE: Auto lookup using EDT with Table reference

do you add the relation?