This documentation is archived and is not being maintained.

ModelRelationship Properties (Excel)

GitHub-Mark-64px

Contribute to this content

Use GitHub to suggest and submit changes. See our guidelines for contributing to VBA documentation.

Name

Description

Active

When True, the relationship is active. When False, this relationship is inactive. Boolean. Read/Write

Application

Returns an Application object that represents the Microsoft Excel application. Read-only.

Creator

Returns a 32-bit integer that indicates the application in which the specified object was created. Read-only Long.

ForeignKeyColumn

Contains the ModelTableColumn Object (Excel) object (Excel) representing the foreign key column on the many side of the one-to-many relationship. Read-only

ForeignKeyTable

Contains the ModelTable Object (Excel) object (Excel) representing the table on the many side of the one-to-many relationship. Read-only

Parent

Returns an Object that represents the parent object of the specified ModelRelationship Object (Excel) object. Read-only.

PrimaryKeyColumn

Contains the ModelTableColumn Object (Excel) object (Excel) representing the primary key column in the table on the one side of the one-to-many relationship.

PrimaryKeyTable

Contains the ModelTable Object (Excel) object (Excel) representing the table on the one side of the one-to-many relationship.

Show: