Let’s get started
Please enter your work or school account to get started.
Data in one entity often relates to data in another entity. For example, you might have a Customers entity and an Orders entity, and the Orders entity might have a lookup relation to the Customers entity to show which customer placed the order. You can use a lookup field to show data from the Customers entity for the customer who placed the order. For more information, see Entity relationships and lookup fields.
You can create several types of relationships from one entity to another (or between an entity and itself). Each entity can have a relationship with more than one entity, and each entity can have more than one relationship to another entity. Some common relationship types are:
Normal - This type of relationship exists between two entities.
Self - This type of relationship exists between an entity and itself.
One-to-one - In this type of relationship, each record in entity A can match only one record in entity B, and vice versa. The current release of the Common Data Service does not support this type of relationship for custom entities.
One-to-many - In this type of relationship, each record in entity A can match more than one record in entity B, but each record in entity B can match only one record in entity A.
Many-to-many - In this type of relationship, each record in entity A can match more than one record in entity B, and vice versa. The current release of the Common Data Service doesn't support this type of relationship.
To add a lookup relation to an entity, create a relation under the Relationships tab and specify the entity with which you want to create a relationship.
If you create an app automatically from an entity that contains a lookup field, it appears as a Drop down control that contains data from the primary key field of the referred entity in a collapsed state. To see two fields in the drop down when it is expanded, you must add the PrimaryId field and a second field of your choice to the Default Lookup field group of the related entity of the lookup relation.
If entity A has a lookup relation to entity B:
Note: If entity B is a standard entity with a parent relationship to entity A and you delete a record from entity A, all matched records in entity B are also deleted.
For information about how to delete a field, see Manage fields.