Tuesday, July 10, 2012

Creating single field as Primary key in AX 2012

Hi Everyone, Hope you all doing well. I have come with the steps of creating the  single field as primary in AX 2012.

1) Create the Table and add required fields to the table as you all knows.
2) Create an Index by dragging the required field to the Index.
3) Set the following Index properties:
        a) AllowDuplicates to "NO".
        b) Alternate key to "YES".
4) Set the  PrimaryIndex  property of the table to newly created index after creating the Index. 

All The Best... :)

Please comment me your suggestions for my posts..


  1. THanks, helped me out. Was wondering why the field wasn't showing up in the primary index property, Alternate key did the trick . :)