Authenticate Emails with SPF, DKIM, and SenderID Auto forward your emails to Vtiger Managing User Profiles Automate Outgoing Emails in Email Settings Automation - Approvals Automation - Assignment Rules Set up Multi-path Workflows Creating a Scheduled Workflow Automation - Scheduler Creating a Workflow Webforms in Vtiger CRM Set up a Workflow Action to Create Event Set up a Workflow Action to Create Records Set up a Workflow Action to Create Task Set up a Workflow Action to Invoke Custom Function Set up a Workflow Action to Create an SMS Task Set up a Workflow Action to Send Mails Set up a Workflow Action to Update Fields Automation - Workflow Action - Webhook Automation - Workflows - Vtiger Expressions Configuration - Business Hours Configuration - Company Details Configuration - Consents Configuration - Customer Portal Maps in Vtiger CRM Configuration - Usage Details Configuring Encrypted Data Fields in Vtiger CRM Configure Picklist Dependencies Considerations for Deactivating Vtiger Users Control Fields and Record Displays using Configuration Editor Create Reminders for Records and Inbox Create a field of a Grid type Dealing with Currencies and Taxes Enable Desktop Notifications on Chrome Web Browsers Vtiger CRM Add-ons IMAP Configuration - 2-way sync between Vtiger and IMAP providers Setting up Autopay & Payment Gateways Inventory - Tax Management Inventory - Terms and Conditions Login to Vtiger on SSO SAML using ADFS Mailroom Functionality for Different Scenarios Manage Multiple Currencies Marketing and Sales - Deal to Project Mapping Marketing and Sales - Lead Conversion Data Mapping Marketing and Sales - Profile Scoring Module Management - Labels Editor Module Management - Module Numbering Configure My Preferences Feature My Preferences - Calendar Settings Tags in Vtiger My Preferences - Notification Preferences SAML Support in Vtiger CRM Vtiger Mailroom Settings - Configure Module Settings Settings - Create Dynamic Fields and Layouts Settings - Customize Records and Fields for your Business Settings - How to set email autoresponder to Webform submission? Settings - Left Menu Settings - Manage Global Picklists in Vtiger Settings - Set up your Support Team Settings - Start Up Page Settings - Working with Picklist Values Module Management - Module Builder Support - SLA Policies Troubleshooting Login Issues Add-Edit Unsubscribe Links in your Email Template User Management - Authentication User Management - Encrypted Field Access Logs User Management - Groups User Management - Login History User Management - Profiles User Management - Roles User Management - Settings Log User Management - Sharing Rules User Management - Users User Management - Vtiger Support Access Vtiger Buzz - Chrome Extension for Notifications Vtiger Implementation wizard Vtiger Language Support Configuring Websense Trackers Websense - Widgets Module Management - Module Layouts & Fields Generate and Manage Third-party App Passwords in Yahoo Configuring App Passwords for Gmail Outgoing Server and Yahoo Mail Configuration - Storage Guard Customizing your Self-Service Portal Theme Using CSS Styles Automation - SMS Reply Actions Adding Hidden Fields to a Webform Configuring Dependent Fields and Blocks for Modules Auto forward Emails from Microsoft Office 365 Adding Custom Module Login Page Customization Settings - Personalize Module Layouts Module Management - Modules Duplicate Prevention in Modules Formula Fields Creating Custom Filters Adding a local DNS Entry

Introduction

 

Not just Tasks, you can create a relationship between any two modules. The purpose of doing this is to enable the linking of related records. 

For instance, consider that there is a contact record and a deal record on your CRM account. To link the deal to the contact, you must relate the Deals and Contacts modules.  

In this article, we will tell you about the different relationship types and how you can relate modules in Vtiger CRM. 

Different Relationship Types

Depending on your requirements, you can create four types of relationships.

• One-to-one
• One-to-many
• Many-to-one
• Many-to-many

Let us learn about them one by one with examples.

One-to-one relationships

A one-to-one relationship relates a single record of Module 1 to a single record of Module 2. You must specify the reference field names for both modules while setting up the relationship.

  

For example, if you want to link only one deal to every contact record, then you can create a one-to-one relationship between the Contacts and Deals modules. A reference field for the related contact and deal is created in the deal and contact records, respectively. 

One-to-many relationships

A one-to-many relationship relates a single record of Module 1 to multiple records of Module 2. In this case, Vtiger CRM creates a reference tab in Module 1 to hold all the related records of Module 2. It also creates a reference field in Module 2 to hold the related record of Module 1.

Here is an example of a one-to-many relationship.

 

When a deal is in the Value Proposition stage, you must send a quote to your contact for approval. There is a chance that the contact does not accept your quote on the first go. So you revise the quote and send it again. In this situation, you create multiple quotes and link them to the deal record. 

Note:

• You can now map fields between a Parent module and a Child module. When you create a child module record from the Parent module, the system automatically copies the field data from the Parent record to the Child record.
• For example:
  • Copying a Contact’s mobile number to Deal record and Invoice record.
  • Copying the date from a Case record to an Invoice record.
• You can map fields for one-to-many and many-to-many relationships (for all modules) from the Modules and Layout > Relationship tab using the Settings icon.
• Clicking the Settings icon opens the Record Template window where you can map Source and Related fields using the Add Mapping button.

Many-to-one relationships

A many-to-one relationship is the reverse of the one-to-many relationship. It relates multiple records of Module 1 to a single record of Module 2. Vtiger CRM creates a reference field in Module 1 and a reference tab in Module 2. 

  

For example, if you send a client’s order in multiple deliveries, then its related purchase order will have multiple receipt notes. 

Many-to-many relationships

A many-to-many relationship relates multiple records in Module 1 to multiple records in Module 2 and vice versa. There will not be a unique relationship between records in Module 1 and Module 2. A tab is created in both modules to hold related records.

  

For example, if there is a many-to-many relationship between the Assets and Quotes modules, you can relate an asset to multiple quotes and a quote to multiple assets. 

Creating a Relationship between Modules

 To create a relationship, we first need to land on the Relationships page.

Follow these steps to view the Relationships page: 

1.  Log in to the CRM.
2. Click the User Menu on the top right corner of the screen.
3. Click the Settings button. You will land on the Settings page. 

4.  Look for the Module Management section.
5. Click Module Layouts & Fields. 

6.  Select a module from the Select Module drop-down. You can pick one of the two modules that you want to relate.
7. Click the Relationships tab. 

Follow these steps to create a relationship: 

1. Log in to the CRM.
2. Click the User Menu on the top right corner of the screen.
3. Click the Settings button. You will land on the Settings page.
4. Look for the Module Management section.
5. Click Module Layouts & Fields.
6. Select a module from the Select Module drop-down. You can pick one of the two modules that you want to relate.
7. Click the Relationships tab.

8.  Click the +Add Relationship button.

9. Select the related module from the Select related module drop-down.
10. Pick the relationship that you want to create from the Select relationship type.
11. Enter the field name of the related records.
12. Enter the tab name of the related records. 
13. Click Save. 

Deleting a Relationship

 You cannot delete the relationships provided in Vtiger CRM by default. You can delete only the custom relationships that you create.

Follow these steps to delete a relationship:

1. Log in to the CRM.
2. Click the User Menu on the top right corner of the screen.
3. Click the Settings button. You will land on the Settings page.
4. Look for the Module Management section.
5. Click Module Layouts & Fields. 

6.  Select a module from the Select Module drop-down. You can pick one of the two modules that you want to relate. 

7.  Click the Relationships tab. 

8.  Select a module to view all its relationships.
9. Click the Delete icon beside a relationship. 

10.  Click Yes to confirm the deletion.  

Add-Edit Unsubscribe Links in your Email Template