Creates a new schema relationship. Returns a SchemaRelationship object.
Syntax
expression.Add(Name, ManySchemaRowsource, OneSchemaRowsource, ManySchemaField, OneSchemaField)
expression An expression that returns a SchemaRelationships object.
Name Required String. Specifies the name of the new schema relationship.
ManySchemaRowsource Required String. Specifies the name of the row source on the “many” side of this one-to-many relationship.
OneSchemaRowsource Required String. Specifies the name of the row source on the “one” side of this one-to-many relationship.
ManySchemaField Required String. Specifies the name of the schema field on the “many” side of this one-to-many relationship.
OneSchemaField Required String. Specifies the name of the schema field on the “one” side of this one-to-many relationship.
Remarks
In design mode in Microsoft Access, the SchemaRelationships collection is automatically filled with the available schema relationships.