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.

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.


  1. Your link to SkyDrive is broken.

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

  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

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

  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.

    Asif Huddani

  6. Good Information. Thanks. Randy Granger


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