Relations Collection

Description

A Relations collection contains stored Relation objects of a Database object (Microsoft Jet databases only).

Remarks

You can use the Relation object to create new relationships and examine existing relationships in your database. To add a Relation object to the Relations collection, first create it with the CreateRelation method, and then append it to the Relations collection with the Append method. This will save the Relation object when you close the Database object. To remove a Relation object from the collection, use the Delete method.

To refer to a Relation object in a collection by its ordinal number or by its Name property setting, use any of the following syntax forms:

Relations(0)

Relations("name")

Relations![name]

Properties

Count property.

Methods

Append method, Delete method, Refresh method.

Example

See the Relation object example.

Example (Microsoft Access)

See the Relation object example (Microsoft Access).