Deleting a record or records.

P

Paul S

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?
 
V

Van T. Dinh

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.
 
Top