Append method (ADOX Keys)
Applies to: Access 2013, Office 2013
Adds a new Key object to the Keys collection.
Syntax
Keys.AppendKey [,KeyType] [,Column] [,RelatedTable] [,RelatedColumn]
Parameters
Parameter | Description |
---|---|
Key | The Key object to append or the name of the key to create and append. |
KeyType | Optional. A Long value that specifies the type of key. The Key parameter corresponds to the Type property of a Key object. |
Column | Optional. A String value that specifies the name of the column to be indexed. The Columns parameter corresponds to the value of the Name property of a Column object. |
RelatedTable | Optional. A String value that specifies the name of the related table. The RelatedTable parameter corresponds to the value of the Name property of a Table object. |
RelatedColumn | Optional. A String value that specifies the name of the related column for a foreign key. The RelatedColumn parameter corresponds to the value of the Name property of a Column object. |
Remarks
The Columns parameter can take either the name of a column or an array of column names.