AX / Dynamics 365 For Finance and Operations blog

AX / D365FO – How to create automatic join relationship between tables in an AOT Query

Are you creating an AOT query and want to join 2 or more tables but don’t know the relationships between them?

No problem! You can use the “Use Relations” property like shown below

In this example I want to to use the native relation between InventSerial and InventSum tables (which is InventSerial.ItemId = InventSum.ItemId).

By enabling “Use relations” property the join is automatically created