![Microsoft Dynamics AX - The Definitive Guide: AX 2012 - Multi Table Lookup - Join many multi with root table to display a lookup on root table Microsoft Dynamics AX - The Definitive Guide: AX 2012 - Multi Table Lookup - Join many multi with root table to display a lookup on root table](https://1.bp.blogspot.com/-rbsD1uJvwKE/WdXKWN7cLPI/AAAAAAAAGZ8/eVnwhsADDGgpAXWqIjU5Mzp7Ldloh61owCLcBGAs/s1600/2017-10-05_10-58-56.jpg)
Microsoft Dynamics AX - The Definitive Guide: AX 2012 - Multi Table Lookup - Join many multi with root table to display a lookup on root table
![How to Create a Dynamics AX Query - AX 2012 Query & Surprises Your Data Can Bring | Stoneridge Software How to Create a Dynamics AX Query - AX 2012 Query & Surprises Your Data Can Bring | Stoneridge Software](https://stoneridgesoftware.com/wp-content/uploads/2017/06/BuildingQueries_BillThompson4.png)
How to Create a Dynamics AX Query - AX 2012 Query & Surprises Your Data Can Bring | Stoneridge Software
![Dynamics AX - Hari: Form data source link types - Active, Delay, Passive, Inner join, Outer join, Exist join, Not exist join Dynamics AX - Hari: Form data source link types - Active, Delay, Passive, Inner join, Outer join, Exist join, Not exist join](http://2.bp.blogspot.com/-Lwxv6PdE_Qw/VCLocm_5w7I/AAAAAAAAAUw/DGuWTQW1390/s1600/1.png)
Dynamics AX - Hari: Form data source link types - Active, Delay, Passive, Inner join, Outer join, Exist join, Not exist join
![How to: Add a new relation for a new field to the same table to which a relation already exists [AX 2012] - Microsoft Dynamics 365 Blog How to: Add a new relation for a new field to the same table to which a relation already exists [AX 2012] - Microsoft Dynamics 365 Blog](https://cloudblogs.microsoft.com/dynamics365/wp-content/uploads/prod/sites/4/2015/12/CustTransExisting.jpg)
How to: Add a new relation for a new field to the same table to which a relation already exists [AX 2012] - Microsoft Dynamics 365 Blog
![How to: Add a new relation for a new field to the same table to which a relation already exists [AX 2012] - Microsoft Dynamics 365 Blog How to: Add a new relation for a new field to the same table to which a relation already exists [AX 2012] - Microsoft Dynamics 365 Blog](https://cloudblogs.microsoft.com/dynamics365/wp-content/uploads/prod/sites/4/2015/12/CustTransOrg.jpg)
How to: Add a new relation for a new field to the same table to which a relation already exists [AX 2012] - Microsoft Dynamics 365 Blog
![bits here and there ...: Error - The number of joins in the statement is 28. This exceeds the maximum of 26. Turn on exception for this warning to see the call stack. bits here and there ...: Error - The number of joins in the statement is 28. This exceeds the maximum of 26. Turn on exception for this warning to see the call stack.](http://1.bp.blogspot.com/-QNf0eD9Nj9k/UU8qUvGbmGI/AAAAAAABCKU/ly795qSpgNQ/s1600/DAX2012_MaxTableJoin.png)