Creates a new related field. Returns a SchemaRelatedField object.
Syntax
expression.Add(ManySchemaField, OneSchemaField)
expression An expression that returns a SchemaRelatedFields object.
ManySchemaField Required String. Specifies the name of the schema field on the “one” side of the one-to-many relationship.
OneSchemaField Required String. Specifies the name of the schema field on the “many” side of the one-to-many relationship.
Remarks
A SchemaRelatedField object describes the column pairings that make up a SchemaRelationship object. The names of these fields are used in generating join clauses in SQL and parent-child relationships in a hierarchy.
Remarks
In design mode in Microsoft Access, the SchemaFields collection is automatically filled with the available schema fields.