Index
Unique Index
Non Unique Index
Unique Index
To set an index as a unique index, you can set the index property called allow duplicates to no. Fields should not to allow edit.To set an index as the alternate key, you can set the alternate key property of the index to yes.Set the primary Index property to the unique index.When a primary index is not specified, AX uses a surrogate key as the primary index.
The ClusterIndex value is given to the underlying Microsoft SQL Server database system as a performance tuning choice. This choice generally controls the physical sequence in which the records are stored in the underlying database.
Relations
Normal
Normal specifies related fields in another table. Multiple fields can be included in this relation.
Field Fixed
Field fixed and related field fixed are conditional relations. Conditional relationships can be created by adding a condition to a table relation. Only records that fulfill the condition are included in the relation. A condition on a relation filters the records on either the table that contains the relation or the related table, depending on the type of condition. Field fixed specifies that the condition is on the table that contains the relation
https://dynamicsaxinsight.wordpress.com/2014/01/23/conditional-relations-with-field-fixed-and-related-field-fixed/
Related Field Fixed
In the above example you can see the related field example. first one relations is created in the cust table for custvenditemgroup table and field of module.
Module is Enum data type, so invent is first value, so if we create new record in the custvenditemgroup table automatically 1 value is assigned to Module field.
Foreign Key
http://axdaily.blogspot.com/2011/05/surrogate-keys-in-ax-2012.html
Unique Index
Non Unique Index
Unique Index
To set an index as a unique index, you can set the index property called allow duplicates to no. Fields should not to allow edit.To set an index as the alternate key, you can set the alternate key property of the index to yes.Set the primary Index property to the unique index.When a primary index is not specified, AX uses a surrogate key as the primary index.
The ClusterIndex value is given to the underlying Microsoft SQL Server database system as a performance tuning choice. This choice generally controls the physical sequence in which the records are stored in the underlying database.
Relations
Normal
Normal specifies related fields in another table. Multiple fields can be included in this relation.
Field Fixed
Field fixed and related field fixed are conditional relations. Conditional relationships can be created by adding a condition to a table relation. Only records that fulfill the condition are included in the relation. A condition on a relation filters the records on either the table that contains the relation or the related table, depending on the type of condition. Field fixed specifies that the condition is on the table that contains the relation
https://dynamicsaxinsight.wordpress.com/2014/01/23/conditional-relations-with-field-fixed-and-related-field-fixed/
Related Field Fixed
In the above example you can see the related field example. first one relations is created in the cust table for custvenditemgroup table and field of module.
Module is Enum data type, so invent is first value, so if we create new record in the custvenditemgroup table automatically 1 value is assigned to Module field.
Foreign Key
http://axdaily.blogspot.com/2011/05/surrogate-keys-in-ax-2012.html
No comments:
Post a Comment