Table relationship eligibility
Before you create a relationship you should confirm whether the table is eligible to participate in the relationship. The following lists the messages that you can use to determine whether tables can participate in relationships.
Note
Unsure about entity vs. table? See Developers: Understand terminology in Microsoft Dataverse.
| Message | Web API Operation | SDK Assembly |
|---|---|---|
| CanBeReferencedChecks whether the specified enttableity can be the primary table (one) in a one-to-many relationship. | CanBeReferenced Action | CanBeReferencedRequest |
| CanBeReferencingChecks whether the specified table can be the referencing table (many) in a one-to-many relationship. | CanBeReferencing Action | CanBeReferencingRequest |
| CanManyToManyChecks whether the table can participate in a many-to-many relationship. | CanManyToMany Action | CanManyToManyRequest |
| GetValidManyToManyReturns the set of tables that can participate in a many-to-many relationship. | GetValidManyToMany Function | GetValidManyToManyRequest |
| GetValidReferencedEntitiesReturns the set of tables that are valid as the primary table (one) from the specified table in a one-to-many relationship. | GetValidReferencedEntities Function | GetValidReferencedEntitiesRequest |
| GetValidReferencingEntitiesReturns the set of tables that are valid as the related table (many) to the specified table in a one-to-many relationship. | GetValidReferencingEntities Function | GetValidReferencingEntitiesRequest |
See also
Customize table relationship definitions
Extend the table definitions model for Dynamics 365
Table relationship definitions
Table relationship messages
Table relationship behavior
Create a 1:N relationship
Create an N:N relationship