The surrogate key that was introduced with AX 2012 is a powerful feature but at times creates ambiguity on the usage. The goal of this recipe is to clarify and showcase examples that use surrogate keys in the possible patterns. This is divided into two sections; the first section will discuss the usage of surrogate keys in a query based report, followed by the second section that details the application in RDP-based reports.
The following steps show how to implement surrogate fields in reports:
Student Markstables. Create these tables and relate the
Student Markstable to the
Studenttable, using the surrogate key. For the