How it works...
The first new concept is the use of the clustered index to control the order that the records are displayed in grid controls. This is simply using the fact that SQL will return records in the order of the clustered index. Composite keys are fine for this purpose, but we just wouldn't usually use them as a primary key.
We also touched on Surrogate keys, which we have so far avoided. The explanation requires a little bit history to understand. These were introduced in AX 2012 as a performance aid and allowed features like the ledger account lookup when entering general ledger journals. The problem is that they are hard wired to be RecId. So, when we added foreign key relations, the field created contained an unhelpful RecId ...
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Read now
Unlock full access