Articles in this section
Authenticate Emails with SPF, DKIM, and SenderID Auto-forwarding your emails to Vtiger Automate Outgoing Emails in Email Settings Automation - Approvals Automation - Assignment Rules Automation - Multi-path Workflows Automation - Scheduled Workflows Automation - Scheduler Automation - Standard Workflows Automation - Webforms Automation - Workflow Action - Create Event Automation - Workflow Action - Create Records Automation - Workflow Action - Create Task Automation - Workflow Action - Invoke Custom Function Automation - Workflow Action - SMS Task Automation - Workflow Action - Send Mail Automation - Workflow Action - Update Fields Automation - Workflow Action - Webhook Automation - Workflows - Vtiger Expressions Configuration - Business Hours Configuration - Company Details Configuration - Consents Configuration - Customer Portal Configuration - Maps Configuration - Usage Details Configure 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 Customize your self-service portal theme using CSS styles Dealing with Currencies and Taxes Enable Desktop Notifications on Chrome Web Browsers Extensions - Extension Store IMAP Configuration - 2-way sync between Vtiger and IMAP providers Inventory - Payments and Subscriptions Inventory - Tax Management Inventory - Terms and Conditions Login to Vtiger on SSO SAML using ADFS Mailroom Functionality in Different Scenarios Manage Multiple Currencies Marketing & Sales - Forecast and Quota Settings Marketing & Sales - Pipelines and Stages 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 My Preferences My Preferences - Calendar Settings My Preferences - My Tags My Preferences - Notification Preferences SAML Support in Vtiger CRM Set up 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 Unsubscribe your Email 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 Websense - Trackers Websense - Widgets Configuration - Storage Guard Adding a local DNS Entry Adding Additional Hidden Fields to a Webform Configuring Dependent Fields and Blocks for Modules Duplicate Prevention in Modules Module Management - Modules Module Management - Module Layouts & Fields

Module Management - Creating a Relationship Between Modules

Learn how to create a relationship between two modules.
S
Sabqat Ruba
9 Mar, 2021 - Updated 6 months ago

Introduction

Have you noticed when you create a task, its related documents, projects, cases, etc. are shown under the tabs on the right?

Ever wondered how that happens?

It works based on the kind of relationships you set up between the Tasks and other modules. 

 

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 at the first go. So you revise the quote and send it again. In this situation, you create multiple quotes and link it to the deal record. 
 

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 the 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 your CRM account.
  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. Click the +Add Relationship button.
  2. Select the related module from the Select related module drop-down.
  3. Pick the relationship that you want to create from Select relationship type.
  4. Enter the field and tab names of the related records. 
  5. 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 your CRM account.
  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.
Home Privacy Policy Terms of Service Security Center Policy & Legal Center Contact Us
© Copyright 2021 Vtiger. All rights reserved.
Powered by Vtiger
Facebook Twitter Linkedin Youtube