Edit

Table relationship eligibility

  • Article

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