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
You should create a foreign key relation in table node for getting the drop down.
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.
better.. thank you!
Hi Tatiana:
I did found that blog, but unfortunately none of the screen shots show up so its not very useful :(
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.
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
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
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.
do you add the relation?
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
André Arnaud de Cal... 291,151 Super User 2024 Season 2
Martin Dráb 229,993 Most Valuable Professional
nmaenpaa 101,156