Which value should you use for the OnDelete property?

You are a Dynamics 365 Finance developer. You have two tables as shown in the following exhibit:

You need to configure Table1 to ensure that records cannot be deleted from Table1 if Table2 contains related records.

Which value should you use for the OnDelete property?
A . None
B. Cascade
C. Cascade + Restricted
D. Restricted

View Answer

Answer: D

Explanation:

Example of Restricted

Suppose we have two tables (Customer & Order) and the relation is of One-To-Many i.e Customer can have many orders.

So on a parent table i.e.(Customer) if I set a delete action property to “RESTRICTED” for Order table. Then If I go and delete the record from a Customer table. It will first check the record in the child table and if exist that warning prompt saying that first we need to delete a record from child table.

Reference: https://amazingax.wordpress.com/2013/01/13/microsoft-dynamics-ax-2012example-of-cascaderestricted-and-cascade-restricted-delete-action-property-for-a-table-relation/