The ForeignTable property stores the name of the table, in which the external key is to be created.
Applies to objects: Relation.
[[Let] RetVal = ] object.ForeignTable [Let] object.ForeignTable = SetVal |
The ForeignTable property syntax has these parts:
Part | Description |
object | Required. A reference to an instance of the object. |
RetVal | Optional. A String type variable. |
SetVal | Required. A String type variable. |
On creating a Relation object, an external key will be created in the table, referenced by the ForeignTable property. This key will be based on the fields of the table, specified in the ForeignName properties of the Field objects that make part of the Fields collection of the Relation object.
The number of fields in the primary and external keys of the referenced table must coincide, that is, all created fields must have different names and ForeignName properties.
....... |
See Also |
Relation Object, Field Object, Fields Object, ForeignName Property, Table Property, CreateRelation Method. |