Relationship type | Description |
System | A parental relationship type automatically defined by Microsoft Dynamics CRM for system entity relationships. You cannot modify this kind of relationship. |
Parental | All operations on the parent entity instance are propagated to the child entity instances (cascade all):
|
Referential | Operations are not cascaded between entities (cascade none):
|
Referential, Restricted | The entity instance can only be deleted if it has no related entity instances. Otherwise, this relationship type is the same as referential. |
Configurable Cascading | Cascading rules can be configured for most actions. For system relationships, you can select the cascading rules for all actions except merge or delete. For custom relationships, cascading rules can be selected for all actions except merge. Cascading on merge is dependent on the referenced entity. If the referenced entity is an account, contact, or lead, the action cascades. Otherwise, it does not. |
This article also gives a good overview of the relationships in CRM
Finally here are a couple of well written articles with videos links
Many to Many
http://www.dynamicscrmtrickbag.com/2010/01/18/many-to-many-relationships/
Self- Referential Relationships
http://www.dynamicscrmtrickbag.com/2008/09/01/entity-relationships-in-dynamics-crm-4/