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…

The correct answer is D. Restricted. 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…

Design and develop AOT elements

Question

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?

Options

ANone
BCascade
CCascade + Restricted
DRestricted

How the community answered

(66 responses)

A
15% (10)
B
6% (4)
C
3% (2)
D
76% (50)

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 Incorrect Answers: B: Example of Cascade: 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 "CASCADE" for Order table. Then If I go and delete the record from a Customer table. It will also delete all the related records in Order table automatically. C: Example of Cascade + Restricted Suppose we have three tables (Person ,Customer & Order) Now Person is a parent of Customer table, and Customer is a parent of Order table having (One-To-Many) relations If I set a Delete action property on Person table to "CASCADE" for customer table and If I set a Delete Action property on a CUSTOMER table for Order table to "CASCADE +RESTRICTED". So if I delete a record from Customer table then It will first check the record in the child table(order table) and if exist that warning prompt saying that first we need to delete a record from But if I delete a record from Person table it will automatically delete a record in Customer table and all records related to customer table in Order table would also be deleted. https://amazingax.wordpress.com/2013/01/13/microsoft-dynamics-ax-2012example-of- cascaderestricted-and-cascade-restricted-delete-action-property-for-a-table-relation/

Topics

#table relations#OnDelete property#referential integrity#table design

Community Discussion

No community discussion yet for this question.

Full MB-500 Practice