quickest way to delete all related records from a found set ???

[Steven Cappiello]

hi there,

I have a found set that will range from 30-300 records.. I need to delete all related records in a table when a user logs in...

what's the quickest way to do this?

I tried looping through the records and doing an "If not isempty(related record), then clear" but it's kinda slow

I thought about going to related records in a tiny window and deleting all the records without dialog... I'll see if that's faster..

I don't need to delete the records... clearing the related field would serve my purposes equally well..

any suggestions ??

thanks :B

[bcooney]

The fastest way is to set up a cascading delete. Edit the relationship btw the parent and child table, check the "Delete Records" in this table on the child side.