Array Elements And Table References

In the previous post we explore the basics Extended data Types in Dynamics Ax 2012. To navigate to previous post go to this Link. http://dynamicsaxedtsandbaseenums.blogspot.com/

In this post we will be exploring the EDT's in some detail which include Array elements and Table References which you can see under the node of your EDT.

ARRAY ELEMENTS:

•    You can create an extended data type in the Application Object Tree (AOT) that contains multiple elements. This enables you to store multiple data elements in a single field that is based on this extended data type.

      Array elements are very useful in the scenario where you want to create such EDT in which that particular EDT can contain similar elements, so instead of creating multiple EDT's you can create Array Elements of that particular EDT...  

This concept will be more clear with the help of an example:

      You have created an EDT for the Address as shown above. Now in this scenario you are required to store 3 addresses. Now one way is to use 3 different EDT's which is not the Best Practice in this case. the other way is to create the Array Elements of the Address EDT, as shown below:

 Now let's see how to create array elements:'

STEPS:

1. In the Extended Data Type node navigate to your EDT
2. Expand Your EDT and navigate to Array Elements Node
3. Right click Array Elements node and select New Array Element

Now let's move to the Table references node...

TABLE REFERENCES:

•        Starting in Microsoft Dynamics AX 2012, We can no longer define relations under an EDT element in the AOT.
•        In previous version of AX there was a References node under the EDT's
•        Now in AX 2012, this has moved to the table relations level.

The following block diagram elaborates the purpose of Table References :

      The block diagram demonstrates that table references Provide a reference of the primary key field of a reference table as a foreign key to the primary table via an EDT, which can be called as Join reference EDT.

     The detailed discussion of the Table References will be covered in the next posts with some examples...

      

     In this post we have covered the Array Elements and Table references... Hope it's useful and informative...

      THANKS...