ForeignName Property

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.

Syntax

[[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.

Remarks

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.

Example

.......

 

See Also

Field Object, Fields Object, Relation Object, CreateRelation Method.