Edit table constraints (form) [AX 2012]

Updated: March 8, 2011

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

Click Product information management > Common > Product configuration models. On the Action pane, click Table constraints. On the Table constraints form, click the Edit button.

Use this form to modify the selected table constraint. Table constraints can be either user defined or system defined.

NoteNote

There are two versions of this form depending on the type of table constraint that is being edited.

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

Tab

Description

Table fields

Select what attributes will be used in the selected table constraint.

Allowed combinations

NoteNote

This tab is displayed when a user defined table constraint is selected.

ImportantImportant

The information that is added on the Table fields tab becomes the column names on the Allowed combinations tab.

Create the combination of options that are available for the table constraint.

For example, if you entered the following information on the Table fields tab:

On the first line, enter TV type in the Name field and select TelevisionType from the Domain field. On the second line, enter TV size in the Name field and select TelevisionSize from the Domain field. On the Allowed combinations tab, TV type and TV size will appear as the column titles. Then you would enter the combinations that are allowed between TV type and TV size.

The TV type of Plasma is only available in a TV size of 42 or 50 and the TV type of Projection is available in a TV size of 50 or 60. The following information would be displayed on the Allowed combinations tab:

TV type

TV size

Plasma

42

Plasma

50

Projection

50

Projection

60

Query

NoteNote

This tab is displayed when a system defined table constraint is selected.

Use the query button to filter the table the constraint is based on.

Button

Description

Validate

NoteNote

This button is displayed when a user defined table constraint is selected.

Click the Validate button on the Allowed combinations tab to validate the selected table constraint.

Select query...

NoteNote

This button is displayed when a system defined table constraint is selected.

Click the Select query... button to create a query to filter the table the constraint is based on.

Field

Description

Name

The name of the selected table constraint.

Description

Description of the selected table constraint.

Type

Displays what type of table constraint is selected. Table constraints can be either user defined or system defined.

Table

NoteNote

This field is displayed when a system defined table constraint is selected.

Displays the name of the table that the table constraint is based on.

Name

Name of the table field.

Domain

NoteNote

This field is displayed when a user defined table constraint is selected.

Select the attribute type in the Domain field.

Field name

NoteNote

This field is displayed when a system defined table constraint is selected.

The field name from the selected table.

Attribute type

NoteNote

This field is displayed when a system defined table constraint is selected.

Select the attribute the table field is related to.


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

Community Additions

Show: