• Release History
  • Documentation
  • Back to www.mscrm-addons.com
  • Release History
  • Documentation
  • Back to www.mscrm-addons.com
home/Knowledge Base/Template Designer(DCP)/How to create relationships using DocumentsCorePack Template Designer (Advanced)

How to create relationships using DocumentsCorePack Template Designer (Advanced)

1963 views 0 Updated on June 1, 2023

This article outlines how to create more complex relationships in the DocumentsCorePack (DCP) Template Designer.

The following three step-by-step tutorials will teach you how to create and manage complex relationships with the DCP Template Designer Additional tab. Essentially, relations can be solved for 1:N (1:many) and N:N (many:many) relationships. All custom entities, as well as system entities, are supported.

Step-by-Step Video:

Tutorial 1: How to add a predefined relationship

Predefined relationships are helpful when you create a common template, for example, a quote template. With a predefined relationship, you do not have to manually create a new template for each quote.

Step 1: Create a new template

For further information on how to create a template, please read this article.

Step 2: Navigate to the “Additional” tab in the Template Designer
Next, open the Additional tab. It has been designed to manage additional relationships.

 DCP Template Designer – Additional tab​
Figure 1: DCP Template Designer – Additional tab​

Step 3: Add a relationship/entity
Click on the Add Relationship/Entity button to open the relationship designer (see tutorial 2), or click on the drop-down arrow to expand a menu with predefined relationships.

The [Add Relationship/Entity]-button
Figure 2: The [Add Relationship/Entity]-button

 

Add Relationship/Entity dropdown menu – predefined relationships
Figure 3: Add Relationship/Entity dropdown menu – predefined relationships

The highlighted area in Figure 3 shows all predefined relationships. DocumentsCorePack already has a variety of different predefined relationships for standard CRM entities ready for you (for example, All Contacts of an Account, Quote Products of a Quote, etc). They facilitate the creation of templates. Simply click on the predefined relationship to add it. The related fields will then be visible in the Template Designer TreeView.

Tutorial 2: How to add a relationship from scratch

When you are dealing with more complex relationships, it can be helpful to create a relationship from scratch.

Step 1: Create a template and insert fields
For further information on how to insert fields, read this article. As you see below, we have inserted the following fields: <<accountid>> and <<name>>

 

Figure 4: Insert Fields

Step 2: Add a new relationship

Next, go to the Additional tab and open the Add Relationship/Entity drop-down menu. Then, select Add New Relationship.

Add new relationship
Figure 5: Add a new relationship

The Configure Fields and Datasource dialog will open. Select a relationship you would like to insert ❶ and add attributes by checking the boxes next to the attributes ❷. In the example below, we have chosen the relationship Account > Activity [regardingobjectid] and added the following attributes: Activity, Actual End, Actual Start, and Due Date.

Add anew relationship
Figure 6: Add a new relationship

The chosen attributes of the entity are now also visible in the Additional tab of the Template Designer. From here, you can insert any of the fields into the document. However, there are usually more complex relationships needed. That is why you may expand the complexity of the relationship by adding more levels.

Resolved Fields
Figure 7: Resolved Fields

Step 3: Add further relationships

If you would like to add further relationships, click Edit in the Additional tab.

For adding further relationships click Edit
Figure 8: For adding further relationships click Edit

This action opens the Configure Fields and Datasource dialog again, providing you with the former established relationship. Select ❶ Add and add another relationship ❷ here. In the example below, we added Activity [activityid] -> Attachment [objected] and the entities ❸ Attachment Number, Entity, File Name, Subject. 

Add another relationship
Figure 9: Add another relationship

As you can see, the resolved entities are now also visible in the Additional tab of the Template Designer. From here, you can insert any of the fields into the document.

Additionally resolved fields
Figure 10: Additionally resolved fields

Please note: You may repeat these steps as often as you would like to in order to enhance the complexity of your relationships.

​Tutorial 3: How to create a relation to a separate entity

The creation of a relation to a separate entity follows the same rules as the creation of an entity from scratch, with one exception. In order to create a relation to a separate entity, follow the steps in Tutorial 2 carefully, but make sure that you change the following parameter when you select a new relationship:

Instead of checking Relationships, check Separate Entities ❶ in the Select existing Relation section. The main difference is that you will now be provided with separate entities ❷ instead of relationships.

Insert separate entities
Figure 11: Insert separate entities

Additional Filtering

The most common additional step when adding a relationship is adding additional filters to limit returned results. For example, if you only want to see active records, you would add an additional filter for that. How to create or modify additional filters is described here.

That’s it! We appreciate your feedback! Please share your thoughts by sending an email to support@mscrm-addons.com.

Was this helpful?

Yes  1 No
Related Articles
  • Integrating JSON data into documents
  • Simplify Contract Processes with Dynamics 365 + E-Signature 
  • How to update the metadata in the DocumentsCorePack Template Designer
  • Working with Product Properties in DocumentsCorePack
  • How to work with the Relationship Manager
  • Using virtual tables in DocumentsCorePack
Latest Articles
  • Template Management in DocumentsCorePack 
  • “Undefined”-labels in Chrome 114 and higher
  • Integrating JSON data into documents
  • Generate large documents using the Multipart-feature of DocumentsCorePack 
  • Recap: DynamicsMinds Conference 2023
Popular Articles
  • DocumentsCorePack Template Designer – Getting Started
  • Where do I find the Unique Organization name in Microsoft Dynamics 365?
  • Step-by-Step: How to configure a One-Click-Action
  • mscrm-addons.com Application Access for Dynamics 365 (App Access) – DocumentsCorePack
  • DocumentsCorePack Online Service Configuration
Top Rated Articles
  • IMPORTANT information for Dynamics 365 online customers using DocumentsCorePack and/or AttachmentExtractor
  • How to activate the DocumentsCorePack connector for PowerApps & Microsoft Flow
  • Step-by-Step: How to configure a One-Click-Action
  • “Undefined”-labels in Chrome 114 and higher
  • “Blocked by Conditional access” error in Azure Active Directory
Categories
  • *News and General Infos* 52
  • Webinars 36
  • Template Designer(DCP 181
  • DocumentsCorePack(DCP 198
  • TelephoneIntegration (TI 65
  • AttachmentExtractor (AE 62
  • PowerSearch (PS 48
  • ActivityTools (AT 59
  • SmartBar (SB 53
  • GroupCalendar (GC 46
Our Vision

“We see it as our purpose to provide products that simplify and speed up our customers’ Microsoft Dynamics 365 experience.”

Knowledgebase
LogIn
mscrm-addons.com
  • Products
  • Online Shop
  • Downloads
  • My Account
About Us
  • About Us
  • Case Studies
  • Newsletter
  • Partner Program
  • Contact
Support
  • Support
  • Terms & Conditions
  • Documentation
  • Webinars
  • Legal Documents
  • Impressum
  • © 2022 www.mscrm-addons.com. All Rights Reserved.