It is critical that we enforce data integrity on the tables we create. AX assists us a lot with this by creating relations. AX will use the relations we created earlier to ensure that data entered through the user interface is valid. Simply put, we can only enter a vehicle group on the vehicle table that exists in the vehicle group table. It is more accurate in this example to say that the data entered in the vehicle group field is validated against the relation; the relation might have an additional constraint.
AX handles that data entry validation, but what happens when we want to delete a vehicle group? The system cannot know the answer to this because we have different scenarios here, as shown in the following table:
Foreign table |
Related table |
Action |
---|---|---|
|
|
Restrict deletion |
|
|
Restrict deletion |
|
|
Cascade |