Cascade Delete Behaviour

Consider the following scenario.


A custom entity, Project has been added to a Dynamics CRM system.

There is a 1:n relationship between Account and Project. The relationship behaviour is set to Cascade All for Delete.

A user has Organization level rights on all privileges for Account and Project except that the privilege is set to None for Delete on Project. A project record, Project A, is parented by Account A.

Running negative queries

Sometimes you need to get a list of records (say contacts) that don't have any related records of a particular type (e.g. appointments).
Unfortunately, this is not possible using Advanced Find as it can only return lists of records that have related records (e.g. contacts with appointments). Yes, you can narrow the related records (e.g. contacts with appointments after a certain date) but not to the extent of querying for contacts with no appointments.