Auto lookup using EDT with Table reference

(0) Share

Report

Posted on by Community Member

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

I have the same question (0)

All responses (13)

Answers (0)

Suggested answer

Martin Dráb 237,699 Most Valuable Professional on at

Like (0)

Report

I see that your table has no ReplacementKey. Create a unique index working as the natural key (it will contain "mycode" field, I assume), set AlternateKey = Yes and use it in table's ReplacementKey property.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Thanks for responding! I already had the unique index created, but set the AlternateKey property

Then added the replacement key: ( I also tried changing isLookup in the screenshot below to yes)

unfortunately it still doesn't work. Do you know if there's a "new EDT" example in the codebase that works? (without a lookup form)

Was this reply helpful? Yes No
Mea_ 60,284 on at

Like (0)

Report

Hey amycww,

Do you have any fields in this index ?

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

do you add the relation?

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

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.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

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

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

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

Was this reply helpful? Yes No
Mea_ 60,284 on at

Like (0)

Report

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.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Hi Tatiana:

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

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

try this:

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

Was this reply helpful? Yes No