Relationship Restrictions

Before you create relationships, it is important to be aware of constraints in the relationships you can add to an object.

• A maximum of 18 indexes can exist for each custom object. This limit includes indexes you create as well as indexes that are created automatically. An index is added automatically for each child field used in a relationship.
• Aggregation relationships have limits that do not apply to association relationships:
  • A maximum of five aggregation relationships can be created for each object.
  • A maximum of four objects can be joined using consecutive aggregation relationships where each object is a parent of another, with object A being the parent of object B, which is the parent of object C, and so on. This limit does not apply to read-only relationships that are automatically created when certain standard menus are used to populate menu fields in the custom object.
  • Self-referencing relationships cannot be configured for aggregation relationships.