1,800
Like
Share
ReportHello AX World,
Developing with the latest and greatest Dynamics 365 for Finance and Operations is fun, but sometimes we also have to deal with temporary solutions made in previous versions. Recently I have to deal with a one.
I needed a CurrencyCode field on my table. The easiest way is to copy it from another table. It's such a great feature to be able to copy application elements here and there. So, I have copied CustTable field Currency to my new table. I did not bother much to copy the relation to the Currency table as well. A relation is required to get an automatic lookup on the form.
A good advice of mine, be aware of what you are copying as you may overlook important things. As I did this time. The problem was that I could not get an automatic lookup shown up on my form.
I have started to examine the relation carefully by going through all the properties and I found the cause of the problem. It turns out that the problem was EDTRelation property, it was set to Yes as so was in CustTable. Not sure why it's not the problem in Customers form, the lookup is showing up there. Let me know in the comments bellow if you know the answer.
This property came in AX 2012 when relations were being migrated from the older versions (AX 2009 and earlier) EDTs. Not sure why they are still in this version. Perhaps, due to enabling an upgrade path from AX 2009.
Once the EDTRelation property was set to No the automatic lookup showed up as expected.
Be aware and take care!
Developing with the latest and greatest Dynamics 365 for Finance and Operations is fun, but sometimes we also have to deal with temporary solutions made in previous versions. Recently I have to deal with a one.
I needed a CurrencyCode field on my table. The easiest way is to copy it from another table. It's such a great feature to be able to copy application elements here and there. So, I have copied CustTable field Currency to my new table. I did not bother much to copy the relation to the Currency table as well. A relation is required to get an automatic lookup on the form.
A good advice of mine, be aware of what you are copying as you may overlook important things. As I did this time. The problem was that I could not get an automatic lookup shown up on my form.
This property came in AX 2012 when relations were being migrated from the older versions (AX 2009 and earlier) EDTs. Not sure why they are still in this version. Perhaps, due to enabling an upgrade path from AX 2009.
Be aware and take care!
*This post is locked for comments