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
. -
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!