Table Relations in dynamics ax

Table Relations

·         Normal to specify relation fields without conditions.

·         Field Fixed to specify relation fields to restrict the records in the primary table.

·         Related Field Fixed to specify relation fields that restrict the records in the related table.

1.       For Normal, enter the following in the Field Relation property pages:

·         In the Field property, select the field in the primary table that relates to a field in the related table.

·         In the Related Field property, select the field in the related table.

2.       For Field Fixed, enter the following in the Field Relation property pages:

·         In the Field property, select the field in the primary table to use to restrict the records.

·         In the Value property, enter the value of the selected field as the filter. This relates only records in the primary table that match that field value. Only numeric values can be entered in the Value property. Field fixed relations can be created only on numeric fields.

Each of the related fields are ANDed in the table relation.

3.       For Related Field Fixed, enter the following in the Field Relation property pages:

·         In the Value property, enter the filter value of the selected field. This causes only records in the related table that match that field value to be related. Only numeric values can be entered in the Value property. Related field fixed relations can be created only on numeric fields.

·         In the Field property, select the field in the related table to restrict the records.

Each of the related fields are ANDed in the table relation.