Too Sandal 2 Lips Too Anita Women Dress Black 8RtqRZw Too Sandal 2 Lips Too Anita Women Dress Black 8RtqRZw Too Sandal 2 Lips Too Anita Women Dress Black 8RtqRZw Too Sandal 2 Lips Too Anita Women Dress Black 8RtqRZw Too Sandal 2 Lips Too Anita Women Dress Black 8RtqRZw Too Sandal 2 Lips Too Anita Women Dress Black 8RtqRZw
SugarCRM Support Knowledge Base Studio and Module Builder Introduction to Relationships and Relate Fields

Too Sandal 2 Lips Too Anita Women Dress Black 8RtqRZw

Overview

Linking various pieces of information together is a vital function of CRM. Sugar® provides three different ways to create connections between modules:

Relationships create a bidirectional connection between two modules. Record A has a link to record B, and record B has a link to record A. Relate and Flex Relate fields, on the other hand, both create a one-way connection between two modules. Record A has a link to record B, but record B shows no reference to record A.

Sneaker Mix Mev Black Men Fashion Vernon Bernie qIYU1z

Both Relationships and Relate-type fields can be created in Studio for existing modules or in Module Builder when creating a new module.

Men Mix Sneaker Mev Navy Vernon Bernie Fashion aqvUwn5

Relationships

In Sugar, Relationships can be created in either Module Builder (for new custom modules) or Studio (for existing custom and stock modules). When a Relationship is created via Admin > Studio, relationship fields and/or subpanels are automatically created to represent a two-way connection between the modules. When a related record is selected in another record's relationship field or subpanel, a Relationship is established in Sugar's database between the two records. There are three different relationship types as follows:

  • One-to-One : One record in the primary module can be related to just one record in the secondary module and vice versa.
  • One-to-Many : The primary module's record will be on the "one" side and show a subpanel containing records from the "many" side.
  • Many-to-Many : This type of relationship allows for both sides to be connected to one or more records on the other side. 

For more information about relationship types, please refer to the article Understanding Relationship Creation Options.

You can also create a circular relationship, which is a module related to itself. A good use case for this is a parent/child relationship within the same module, such as the stock Parent Account field. Circular Relationships can be created using any of the above relationship types.

Detailed steps for relationship creation can be found in the article Creating a RelationshipBernie Mev Mens Mev Mev Black 0zF048r.

Relate Fields

2 Too Lips Black Too Anita Dress Sandal Women Sandal Anita Women Black 2 Too Dress Lips Too Sugar administrators can create Relate fields via Admin > Studio, which creates a one-way relationship between two modules. You can add multiple Relate fields in a module. Unlike Relationships in Sugar, you will not see a Relate field or subpanel in the related module record when using the relate-type field. You will only see the Relate field and the associated module link in the module where the Relate field exists.

For example, a contact Relate field for the Cases module will appear on the case record as a hyperlink to a related contact. But if you were to click on the hyperlink to view the contact, you would not see any evidence of the case relationship on the contact record or in its subpanels.

When a Relationship exists between two modules, a new custom relate type field will have no effect on that existing relationship. Relationships automatically generate a Relate field and subpanel between the modules due to the two-way relationship, which is separate from a Relate type field.

Detailed steps for Relate field creation can be found in the article Creating a Relate field.

Lips 2 Sandal Anita Women Dress Too Too Black Flex Relate Fields

Flex Relate fields are similar to Relate fields in that both create a one-way relationship to the related module, but with Flex Relate fields, the user has the freedom to specify a related record from any module. The user is presented a dropdown list of available modules when they edit a Flex Relate field. A good example of a Flex Relate field is the stock Related To field in the Notes module where the user can choose to relate a note to any record from any module in the system.

Note: You can only add one Flex Relate field to a module, so if a Flex Relate field already exists in a module, you will not see "Flex Relate" as an option in "Data Type" when creating the field.

Detailed steps for Flex Relate field creation can be found in the article Creating a Flex Relate field.

Black Women Bernie Beth Sneaker Mev Fashion w1wTpBOq

Sandal Leather Original Women Teva Brown OwqpHS64Quick Tips

  • To determine if a Relate field is by virtue of a Relationship or a custom field, check the field list in Admin > Studio > {Module Name} > Fields. If the field appears in the field list, it is a custom relate or flex relate type field and does not represent a Relationship between the two modules.

  • Occasionally, multiple fields can have the same display label. For example, if you see two Relate fields in the Bugs module labeled "Contact Name", you can temporarily change one of the field names in Studio to distinguish between the two. Alternatively, Google Chrome's Inspect Element feature can also be used to help identify the database names of the fields displayed in the module's layouts. Since every field in Sugar has a unique database name, this will help to distinguish between the fields.

Similarities and Differences

  1. Both the Relate and Flex Relate type fields will appear as editable fields in Studio once created. However, Relate fields generated from a Relationship will not appear in Studio.
  2. When editing a record, the relationship's Relate field and the Relate type field will appear in the same format. The Flex Relate type field is unique because it will contain the dropdown list to select a module to relate the record to.
  3. In record view layouts, the relationship's Relate field, Relate type, and Flex Relate type fields will all appear the same. All three fields will show the record name with a hyperlink to view the related module record.
  4. Relate type fields created in Studio will have database names ending in "_c", while the database name of a Relationship's Relate field will not end in "_c". Third-party tools such as the Chrome™ browser's "Inspect Element" can be used to display the database name to distinguish the fields.
  5. Relate fields created from Relationships are automatically added to the module's layout by default. However, the Relate type and Flex Relate type fields will need to be added to the record view layout by the administrator.

Deciding Which Type to Use

Before creating a Relationship, Relate field, or Flex Relate field, please consider the key features of each type to determine which one best meets your organization's needs.

Use Relationships when you wish to create a two-way connection between two modules (e.g. Accounts and Contacts).

  • Advantages : Using a Relationship is logically and structurally very powerful. You will be able to view and access the module record from both the primary and related module record via a Relationship field or subpanel. When creating a report for the primary or related module, you can access and select the related module's fields to include in the report.
  • Lips Too Dress Too Women Sandal 2 Anita Black Disadvantages : Extensive use of relationships in addition to calculated fields may affect your instance's performance.

Use Relate fields to create one-way relationships between two modules where the module in which the Relate field exists (e.g. Cases) displays the record link to the related module (e.g. Contacts) record.

  • Advantages : Relate fields are easy to create and do not affect performance.
  • Disadvantages : Only the target module (Cases) will display the related module (Contacts) record via the Relate field and enable access to that record. You will not be able to view any information of the target module (Cases) record from the related module (Contacts) record.

Use a Flex Relate field if you wish to have the ability to choose from a list of modules when creating and editing the primary module record. Please note that this creates a one-way relationship between both modules just like the Relate field.

  • Advantages : Flex Relate fields provide the flexibility to relate a record from a variety of modules to the target module record. Flex Relate fields do not affect performance in Sugar.
  • Disadvantages : Only one Flex Relate field can be used in each module. Also, only the target module record will display the related module record via the Flex Relate field and enable access to that record. You will not be able to view any information of the target module record from the related module record.

 

Last modified: 2018-08-09 19:38:04