How to determine the type of a Related List

The related list type is determined by reviewing the list controls for the related list. There are three types of relationships that can be represented by a related list:

• One-to-many
• Many-to-many
• Defined

Procedure

To determine the related list type:

1. Navigate to the related list to investigate.
2. Right-click the column header and select Configure > List Control. The Related List Control form appears.
3. Review the Related list field. This field indicates the type of related list based on the field value format. If the field value follows the format below, the related list uses a one-to-many or many-to-many relationship. In other words, this indicates the related list is built on relationships, and not on an arbitrary user query used to create a defined related list.
   
   In this example, the Related list field indicates a related list built from the [task_sla] table by a reference field called task, pointing to a parent table called incident.
   
   
   
   
4. To further determine if the related list uses a one-to-many or many-to-many relationship, click the reference icon to open one of the records in the related list. Open the record in a new window to see the URL.
   
   In this example, the URL indicates a one-to-many related list. The record opened belongs to the [task_sla] table and shows the unique ID number for the specific record.
   
   
   
   In the following example, the URL indicates a many-to-many related list. A many-to-many related list uses a joiner table. Opening the reference icon from a many-to-many related list takes the user to the joiner table. In the example below, the record opened belongs to the [u_m2m_problems_case_failures] joiner table and shows the unique ID number for the specific record.
   
   
   
   
5. Right-click the label of the field that creates the reference to the parent table.
   
   In the one-to-many related list example below, right-click the Task field to view the field that creates the reference to the parent table.
   
   
   
   In the many-to-many related list example below, right-click the Problem field to view the joiner field that creates the reference to the parent table.