Set Foreign Key for Table Field

Source: R/hsSetForeignKey.R

Set foreign key constraint for a table field

hsSetForeignKey(
  mdb,
  tbl,
  field,
  ref.tbl,
  ref.field,
  key.name = .getForeignKeyName(tbl, field, ref.tbl, ref.field),
  dbg = FALSE
)

Arguments

mdb

full path to MS Access database file (*.mdb)
tbl

name of table containing the field for which the foreign key constraint is to be defined
field

name of table field for which the foreign key constraint is to be defined
ref.tbl

name of table containing the referenced foreign key field
ref.field

name of foreign key field in ref.tbl
key.name

optional. Name to be given to the foreign key
dbg

passed to hsSqlQuery