Relation members (DAO)

Article
03/21/2022

Applies to: Access 2013, Office 2013

A Relation object represents a relationship between fields in tables or queries (Microsoft Access database engine databases only).

Methods

Name	Description
CreateField	Creates a new Field object (Microsoft Access workspaces only).

Properties

Name	Description
Attributes	Sets or returns a value that indicates one or more characteristics of a Relation object. Read/write Long.
Fields	Returns a Fields collection that represents all stored Field objects for the specified object. Read-only.
ForeignTable	Sets or returns the name of the foreign table in a relationship (Microsoft Access workspaces only). .
Name	Returns or sets the name of the specified object. Read/write String if the object has not been appended to a collection. Read-only String if the object has been appended to a collection.
PartialReplica	Sets or returns a value on a Relation object indicating whether that relation should be considered when populating a partial replica from a full replica. (Microsoft Access database engine databases only). Read/write Boolean.
Properties	Returns the Properties collection of the specified object. Read-only.
Table	Indicates the name of a Relation object's primary table. This should be equal to the Name property setting of a TableDef or QueryDef object (Microsoft Access workspaces only).