Finding a "ghost" reference

[cricketbird]

Whenever I try to add a new record to a form, I am getting a message that "You cannot add or change a record because a related record is required in table "TableDietOld".

I did create a table with this name when I was fiddling with the database. However, it no longer exists. I am trying to find what is trying to refer to this old table and I cannot find it.

I have tried:
1) Creating a new table with that name, and then running "Object Dependencies" (nothing)
2) Searching the project's VBA code (nothing)
3) Looking at all of the queries that underlie my form and its controls (nothing)
4) Importing all my objects into a new database (same issue) in case mine had gotten corrupted.

Where else can I look to find this wayward reference to a long-gone table?

:banghead:

Thank you,
CB

 

[GinaWhipp]

Go to the Relationship window and press *All Relationships*, find the *ghost* table and delete it.

 

[cricketbird]

Since the table doesn't exist, that didn't work. However, one table was linked to another database, and apparently someone else had named a table the same as my old table in THAT database, and the relationship was from there. Thanks for your help!

 

[GinaWhipp]

Hmmm, I thought THAT Relationship would show itself in the Relationships window. Oh well... glad you got it fixed!