Deleting a record or records.

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

Guest

I would like to delete some records, however, when I try to do so I can't
because there are related tables. For example: I have a table for clients
and another table for members. So they are related. Is there an easy way to
delete all information for a person in the client table and member table?
 
Set the Cascade Delete option on in the relationship and then delete the
Record in the "One"/Parent Table and JET will automatically delete the
related Records in the "Many"/Child Table.

Alternatively, you will need to delete the related Records in the "Many" /
Child Table first before you can delete the corresponding "One" / Parent
Record since you have set the Referential Integrity on the relationship.
 
You must log in or register to reply here.

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

Record-Locking remains open after closing 0
Access 2002 (membership/subscription records) 3
Linked SQL Tables don't report Cascading Updates and Deletes 2
Subform causes Main Form to show the same record multiple times 9
Appending records 1
DELETE FROM a table WHERE... 1
Error 3201 You can't add or change a record...when delete/deleting 2
Wrong message with cascading deletes 13

Back
Top