Error when deleting

[bdam]

"This operation cannot be performed because one or more required related tables are missing."

I have a fairly complex database and am using the "Delete related records ..." feature somewhat liberally.

What are the usual suspects with this error? I've triple checked my relationships, all the tables are present and accounted for. I don't see any table missing.

[mr_vodka]

Have you check all the relationships in your other files as well and not just in the main file that you are running the script from?

[bdam]

I did and everything looks fine there as well. There are only two files involved, although one of them has many tables and the other two.

Your suggestion helped me find something though. If I have both files open (showing) then I get the error. If I close the parent I can delete from the child and then re-open the parent again and delete there.

Edited March 15, 2007 by Guest