Select related tables (form) [AX 2012]

Updated: February 24, 2011

Applies To: Microsoft Dynamics AX 2012 R3, Microsoft Dynamics AX 2012 R2, Microsoft Dynamics AX 2012 Feature Pack, Microsoft Dynamics AX 2012

Click System administration > Common > Data export/import > Definition groups. Select a definition group and then click Select tables. Select Specify related tables to enable the Select related tables button, and then click Select related tables.

Use this form to add tables to a definition group that are related to one of the tables in the group by primary key or foreign key relationships.


Exporting data using a definition group that includes related tables should be done during off-peak hours only.

The following tables provide descriptions for the controls in this form.




Decrease the number of table relationship levels to include in the list of tables returned by the form.


Increase the number of table relationship levels to include in the list of tables returned by the form.

Select all remaining levels

Select all tables that are related to the initial table.



Select all tables in list

Select this check box to include all tables returned by the form. Clear the check box to clear all tables returned by the form.

Name of table

The name of a related table.


The level of the relationship.

A table relationship level indicates how closely a table is related to the selected table.

For example, if the VendTable is the table that you are selecting related tables for, it has one relationship level with the TaxVatNumTable through the CompanyInfo table. The single relationship level means that the VendTable and the TaxVatNumTable both have a relationship to the CompanyInfo table. The VendTable has two relationship levels with the LogisticsAddressCountryRegion table through the TaxVatNumTable. The two relationship levels mean that the VendTable has a relationship with the TaxVatNumTable, and that the TaxVatNumTable has a relationship with the LogisticsAddressCountryRegion table.

There are often multiple relationship paths between related tables, so the same tables may appear with different relationship levels as you are working with them.

Table that has relationship

The table that contains the field that has either a primary key or foreign key relationship with the selected table and the related table.

Informational fields

The following fields provide additional information about the tables that might be included in the definition group.

Start table – The name of the table that related tables are being identified for. This information is also visible in the title bar of the form.

Relationship levels found – The number of levels of relationships found.

Related tables found – The total number of related tables.

Related tables selected – The number of related tables currently selected for inclusion in the definition group.

Announcements: To see known issues and recent fixes, use Issue search in Microsoft Dynamics Lifecycle Services (LCS).