Hi to all, I am wondering if it is possible to use VBA to create
relationship? Example if possible.
strSQL = "ALTER TABLE MyTable " & vbCrLf & _
"ADD CONSTRAINT MyFK FOREIGN KEY MyField " & vbCrLf & _
" REFERENCES MyOtherTable(MyOtherField);"
db.Execute strSQL, dbFailOnError
Of course, there is always the long way round. Check the help files for the
Relationships collection for further information.
HTH
Tim F
