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.

Message
Web API operation
SDK Request class
Description
CanBeReferenced
CanBeReferenced Action
CanBeReferencedRequest
Checks whether the specified table can be the primary table (one) in a one-to-many relationship.
CanBeReferencing
CanBeReferencing Action
CanBeReferencingRequest
Checks whether the specified table can be the referencing table (many) in a one-to-many relationship.
CanManyToMany
CanManyToMany Action
CanManyToManyRequest
Checks whether the table can participate in a many-to-many relationship.
GetValidManyToMany
GetValidManyToMany Function
GetValidManyToManyRequest
Returns the set of tables that can participate in a many-to-many relationship.
GetValidReferencedEntities
GetValidReferencedEntities Function
GetValidReferencedEntitiesRequest
Returns the set of tables that are valid as the primary table (one) from the specified table in a one-to-many relationship.
GetValidReferencingEntities
GetValidReferencingEntities Function
GetValidReferencingEntitiesRequest
Returns the set of tables that are valid as the related table (many) to the specified table in a one-to-many relationship.

See also

Table relationship definitions
Work with table definitions using the SDK for .NET
Create and retrieve table row relationships
Table relationship messages
Configure table relationship cascading behavior