delete record from

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a master table which has a one-to-many relationship with other tables.
The referential integrity, cascade and delete is all checked, however when I
delete a record from the master table, the values in the other table do not
get deleted. Am I missing something? Please help.
 
In the Relationships window I'd first check that the relationship
shown is the one you intended viz the one and the many sides. I would
then doubleclick the relationship line and either fix the join type
and / or put in the missing check mark for Cascade Deletes.

HTH
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Wrong message with cascading deletes 13
Linked SQL Tables don't report Cascading Updates and Deletes 2
Occasional crash when deleting a record 4
Cascade Delete not working 10
Cascade Delete disabled 1
Cascade Delete Relationship Question 2
referential integrity selected but cascade delete is greyed out 3
Breaking and reestablishing relationships 4

Back
Top