Common:Working with Related Objects

From AgileApps Support Wiki

Reading the Relationship Grid

The relationship grid displays objects that are related to the current object by Lookup fields, and shows how the objects are related:

In the Cases object, for example, in the Object Relationships the relationship grid contains lines that look something like this:

Relationship Type Object Alias ...
Many to One Accounts

The way to read that line is "Many (Cases) to One (Account)". Or, in general terms:

"Many (of the current object) to One (of the object on this line)"

The grid columns show:

Column Content
Relationship Type Cardinality of the relationship: One to many, many to one, or many to many.
Object The object at the other end of the relationship. Click this link to Manage the Object Relationship.
Alias The name given to the relationship, for use in Composite Object operations.
Junction To If the relationship is many to many, then the object is a Junction Object. This column gives a link to the object on the other side of the junction.
Cascade Rules In this section, you establish the Cascade Rules that govern Composite Object operations.

Editing Relationships

To change an object relationship, click the name of the related object in the grid.

Considerations
  • For Many to One relationship, only Alias and Update Cascade Rule is available to update
  • Relationship Alias is a required field and it should be unique for a given base object
    • Alias cannot be "Users" or "User"
    • A Relationship Alias can only contain alphanumeric characters or the underscore (_) character

Deleting Relationships

Relationships are formed by Lookup fields. To delete a relationship, delete the lookup field that created it.