Code highlighting

Saturday, May 07, 2011

Tutorial: Table Relation properties in AX 2012

As many of you already know, Microsoft has put in a lot of effort into normalizing the tables in AX 2012 and consolidating all the data modeling tools in one place - the table itself. As part of this effort, a number of new properties have been introduced on Tables, and in this post I would like to cover some of them, namely the properties on Table Relations.

The new properties you will find on a Table Relation in AX 2012 are:
  • Cardinality
  • RelatedTableCardinality
  • RelationshipType
  • Role
  • RelatedTableRole
  • UseDefaultRoleNames
  • CreateNavigationPropertyMethods
  • NavigationPropertyMethodNameOverride

Hua Chu from the AX team has written a Guideline document, explaining how these properties should be set for Relations you add to Tables in AX. Note that in AX 2012 most of the above information is not actually used at runtime. This is something that will happen in future releases.
I have modified the document so that it contains the information relevant for partners and customers extending the standard application and have uploaded it to my OneDrive.

The document requires certain knowledge of Entity Relationship Modeling (ERM) and UML notation.

Disclaimer:
This document is intended as a guideline only, and should not be used as a Step-by-Step instruction.
Changes to any of the described functionality might still happen before AX 2012 RTM.


Your feedback and questions are, as always, welcome.

7 comments:

  1. Your link to SkyDrive is broken.

    ReplyDelete
  2. The link to (Hua Chu's?) a PDF:

    http://wr4szw.bay.livefilestore.com/y1pRHxJuqX_oO2bPUtNjrqF2VHA0S955wMKik4qhlBanK6Np8aKF7xS4jiMReu5eD_6-yxJCRw8eoCV51x_LQ1BcdfBb_WBYQnA/Microsoft%20Dynamics%20AX%20AOT%20Table%20Relation%20Properties%20Guideline.pdf

    ReplyDelete
  3. Hej Jan,

    Well, I see you got to the direct link, so I assume it's not broken. You simply needed to log in to Windows Live with your Live ID.
    Anyway, thanks for posting the direct link. I avoided that, because I am not sure how SkyDrive works underneath, and whether this link will stay the same in 2 months time, for example

    ReplyDelete
  4. Thank you for the post!
    Great to see the efforts in the technical side of AX2012.
    Regards,
    Philippe

    ReplyDelete
  5. Superb one... Can you let me know in deep reslationship with Customer and Address and SalesTable Realationship i am currently looking to customize ax and need to learn in deep. If you have other material to share then it's appriciated your help.

    Thanks
    Asif Huddani
    huddani_asif@hotmail.com

    ReplyDelete
  6. Good Information. Thanks. Randy Granger

    ReplyDelete

Please don't forget to leave your contact details if you expect a reply from me. Thank you