Module 05 - Types of Entity Relationships Flashcards
What are relationships?
Relationships are used to describe the interactions between records.
What are 1:N relationships?
One to many. Relationships between one primary entity record (parent record) and can be linked to multiple records (child records) of the related entity.
How is this 1:N relationship maintained?
Relationship maintained by lookup field auto created y the platform on the related entity. Stores reference to parent record’s GUID, and because many records can have same primary GUID, 1:N is maintained.
What do you have to enter when you create a 1:N relationship?
A display name, and a schema name for the lookup field.
Which field is not automatically added to a related entity’s form?
The lookup field you require, you must manually add. It is present in the list of available fields for the related entity.
Is there a difference between 1:N and N:1?
Nope, only depending on which “end” of the relationship is being considered. Primary entity is always the “1” and related entity is the “many”.
Can you create a 1:N relationship from the primary entity and the related entity?
Yes, you can create a 1:N relationship from either the primary entity or the related entity.
What is an N:N relationship?
A primary record that is linked to many related records, and a related record can relate to many primary records.
How can you create N:N relationships in CRM?
A combination of system entities and custom entities.
What is the intermediate table?
How the N:N relationships are implemented in the database. The intermediate table links two entities involved. It is also known as the intersect entity, link entity or linking table. Each entity in N:N relationship has 1:N relationship with intersect entity.
What is a native N:N relationship?
Feature of the application, created and managed in a standard way.
What is a manual N:N relationship?
Relationship formed by a third entity to provide a “bridge” between two other entities.
What does the intersect entity contain , if its a native N:N relationship between two entities?
For each pair of records; Primary GUID of intersect record, Entity 1 record GUID (lookup field), Entity 2 record GUID (lookup field).
What restrictions apply to the intersect entity?
Cannot be customized, columns cannot be added, cannot be queried directly, is not available for workflow rules as trigger, or to be created/updated.
Where is the associated view displayed?
The associated view of one entity from the other entity is displayed from the second entity in the relationship and not from the intersect entity. Because N:N is symmetrical, associated view is used from either entity to add associated records.
What is always enabled on the intersect entity?
Auditing. Can view audit history for intersect from either related entity, and who made/removed association and when.
What privileges must a user have to create N:N between two records?
Append and Append to privileges on both entities. Also required to disassociate records.
A manual N:N will not appear where as an entity?
It will not appear in the N:N node as an entity. It is a convenient way to describe how you can use a custom entity that has two lookup fields for the N:1 relationships to the two entities you want to connect.
What is the main benefit of creating N:N relationship manually?
You can add custom fields to the intersect entity.
What is the main disadvantage of creating a manual N:N relationship?
The two related entities are not directly linked using a true relationship. Additional views will have to be created on either entity.
There are some system entities that are used to link records together. Name two.
Queues. Follows.
How to create an entity relationship?
CRM > Settings > Solutions > Select solution > Expand entities > Expand entity from which relationship is to be created > select required type 1:N, N:1, N:N > click New > configure relationship.
What is the primary entity?
Entity for which there is one record in each relationship. When you create 1:N this is complete and has the entity you started from, cannot be changed.
What is the related entity?
Entity for which there are many records in each relationship. This is already completed and has the entity you started from if creating a N:1 relationship, cannot be changed.
What is the Name field for a relationship used for?
Name for the relationship, name is generated from schema names of two entities. You can change the name. When both entities are custom, you’ll have solution prefix repeated.
What does the Searchable option in the relationship definition do?
Allow relationship to show in the Advanced find. Allowed by default.
What is the Display name for the lookup field created for the relationship?
Specifies the label that is used for the lookup field on the related entity.
What is the name for the lookup field created for the relationship?
This is the schema name of the lookup field. Automatically completed by system using the Display Name and Id suffix.
Field requirement for the lookup created for the relationship?
Same requirement levels as for any other field. Suggest Business Recommended to avoid creating orphans.
Best practice for naming convention of lookup fields?
Suffix “Id” or other to remind devs that it is a lookup field.
What can you do with the Display Option for the Primary entity?
Use plural name, Use Custom label, Do not display
When would you want to use a Custom Label?
Useful to give navigation link a name more specific to the context. Need to enable in Display Option first.
Display Area?
You can select area that should display link to related entity.
Display Order?
An integer value that determines the default order in which the related custom entity appears in the navigation bar in the Display Area selected.
How else can you create a 1:N relationship?
You can create a field that has a lookup type, from the fields node under an entity in the solution explorer. However other properties like the navigation pane and relationship behaviours are not available to modify.
What is the Relationship entity name?
Name for the intersect entity. Has the same value as Name property by default.
What is the Relationship behaviour?
Refers to whether certain actions performed on the primary entity cause the same actions to occur on related entities. In every 1:N relationship you can configure actions that are cascaded to related entity and which records of the related entity they apply.
What is a Parental Relationship?
One or more actions that are performed on the primary record are also performed on the related records.
What is a Referential Relationship?
Actions that are performed on the primary record are not performed on the related record.
An entity can only have one what?
One N;1 parental relationship with another entity. Any other N:1 relationship must be referential.
A parental relationship establishes a sense of belonging or exclusivity, which means?
That the related record belongs to the primary record more than to any other record.