Wednesday, March 20, 2013

How to Create Primary Key Table in AX 2012


Follow below steps to create primary key in a table in AX 2012. It can consist of single field only. You can not use more than one fields. If you use more than one fields than it will only appears in Cluster Index Property.

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.

No comments:

Post a Comment

Use Chain Of Command with Examples

 Dear Friends Here is an example of using Chain of Command for form datasource methods. [ExtensionOf(formDataSourceStr(<<Form Name>...