2. ASPRunnerPro General questions
  3. Cascade delete record(s)
This topic is locked

Cascade delete record(s)

 		11/7/2006 1:15:09 PM
ASPRunnerPro General questions
B
 bdegnan author

I have a multi-level set of master-detail relationships. For example,
Company

>Contact

>>Contact History
How do I get the contact and contact history records to be deleted if I delete the company record? Do I need to have an event that runs some SQL upon deletion of the company record or is there a switch somewhere in ASPRunner that will take care of this?
Thanks!
J
 		Jane 11/8/2006

Hi,
it's database-related problem.

You can setup relationship between Company and Contact tables, Contact and Contact History tables, add foreign keys and turn on foreign key constraint and cascade deleting.

It's different for the different databases.

Here are some links with examples:

http://www.informit.com/guides/content.asp...Num=53&rl=1

http://www.aspfree.com/c/a/Database-Code/C...-SERVER-2000/3/
B
 		bdegnan author 11/8/2006

Thank you!