Deleting Record Script

[dajamle]

Hi there,

I want to create a script that will delete all related data. This is how things look...

It's a college library system, for example, each book has two copies, and each copy has two loans. If I need to delete a book, it will create invalid data in the 'loans' and 'copies' tables. Is there anyway I can create a script that will go through copies and then loans to delete all the data.

This is probably a simple loop answer, but I'm a newbie, so please forgive me .

[aaa]

Create relation with checking "When deleting record, delete record from other file"

[Vaughan]

AAA's suggestion (sorry don't know your name) is probably the simplest and most reliable and secure. Automatic too.

An alternative is to use the Go to Related Record script step to "find" the related records, then ran a script in the related file that deleted the found set. I'm always very wary about running a script that deletes the found set of records without warning: better be really sure it's the right found set!

[dajamle]

Thanks for your help guys. Much appreciated.