The ForeignName stores the name of the field of the table, referenced by the Relation table, on which the external key will be based.
Applies to objects: Field.
[[Let] RetVal = ] object.ForeignName [Let] object.ForeignName = SetVal |
The ForeignName 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. |
The ForeignName must be necessarily set to all Field objects, located in the Fields collection of the Relation object.
All ForeignName properties must have different values. The fields, specified in ForeignName must exist in the referenced table.
....... |
See Also |
Field Object, Fields Object, Relation Object, CreateRelation Method. |