Delete records

C

Craig

Is there a way to block a group of linked records and delete them, they have
associated records attached and I am unable to so far

craig
 
D

Dirk Goldgar

Craig said:
Is there a way to block a group of linked records and delete them,
they have associated records attached and I am unable to so far

If you enable Cascade Delete Related Records on the relationship (as set
out in the Relationships window), then deleting a record on the "one"
side of a one-to-many relationship will automatically delete the related
records on the "many" side. Assuming that's what you want to do, that's
probably the simplest way to do it. If you want to delete the related
records but don't want to cascade deletes, you'll have to delete the
related records from the many-side tables first (possibly by running
delete queries), and only then delete the records from the one-side
table.
 

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

Top