Databases Reference
In-Depth Information
14.8.10 Relations
A
Relation
object represents a relationship between certain fields in tables or queries. The
Relation
object can be used to view or create relationships. The
Relations
collection
contains all
Relation
objects for a given database. We will discuss how to create a
relation in .
14.8.11 Containers
The Microsoft Jet engine provides the
Containers
collection as a location where a host
application, such as Microsoft Access, can store its own objects. This is done through the
use of
Container
objects, as shown in Figure 14-13.
Figure 14-13. Container objects diagram of the MS Jet engine
The Jet engine itself creates three
Container
objects:
A
Databases
container object, containing information about the database
•
A
Tables
container object, containing information about each saved table and
query
•
A
Relations
container object, containing information about each saved
relationship
•
It is important not to confuse these
Container
objects (which are
not
collections, despite
their names) with the
Databases
,
TableDefs,
and
Relations
collections. Indeed, these
objects are at entirely different locations in the DAO object hierarchy and serve different
purposes, as we will see.