Edit table constraints (form)
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.
Note
There are two versions of this form depending on the type of table constraint that is being edited.
Navigating the form
The following tables provide descriptions for the controls in this form.
Tabs
Tab |
Description |
||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|
Table fields |
Select what attributes will be used in the selected table constraint. |
||||||||||
Allowed combinations |
Note This tab is displayed when a user defined table constraint is selected. Important 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:
|
||||||||||
Query |
Note 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. |
Buttons
Button |
Description |
|---|---|
Validate |
Note 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... |
Note 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. |
Fields
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 |
Note 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 |
Note This field is displayed when a user defined table constraint is selected. Select the attribute type in the Domain field. |
Field name |
Note This field is displayed when a system defined table constraint is selected. The field name from the selected table. |
Attribute type |
Note This field is displayed when a system defined table constraint is selected. Select the attribute the table field is related to. |
See also
Constraint-based product configuration model details (form)
Announcements: To see known issues and recent fixes, use Issue search in Microsoft Dynamics Lifecycle Services (LCS).