Delete records

  • Thread starter Thread starter Craig
  • Start date Start date
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
 
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
Click to expand...

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