Simple summary Keys are in Dynamics AX
-
There is a maximum of one
Primary Key
per table, whereas a table can have severalalternate keys
. Theprimary key
is usually the type of key that other tables, called child tables, refer to when aforeign key
field in those other tables need a relational identifier. -
For new tables the default is a
primary key
based on theRecId
field , incremented number or a completely meaningless number that is generated by the systemsurrogate key
.A surrogate key
is a system-generated value that acts as the primary key of a table. This value is typically used instead of a set of fields called the natural key which would typically act as the primary key of a table. Microsoft Dynamics AX 2012 uses Recld as thesurrogate key
. -
Alternate key
can be chosen as theReplacement Key
of a table that can display on forms instead of a meaningless numericprimary key
value. Each table can have a maximum of onereplacement key
. -
Natural key
has meaning to people. Mostreplacement keys
arenatural keys
. -
Relations represents a
foreign key
.
Thank you for reading!