In lagbolt's code snippet, "ForeignName" should be replaced with Name.
"Name" contains the name of the table as referenced in the working database. "Foreign Name" is the name of the table linked to in the "other" database.
In my test data base I had a local table called "Animals" and a linked...