Delete Command Button 1

[makala]

I have a delete button on a form. I would like for it to delete the current record and also any corresponding records with this one delete button.

Example:

I want to delete a rack record, when I delete the rack record I also want the corresponding Patch Panel and Circuit records deleted.

How would I go about doing this?

 

[WantsToLearn]

Hello Makala,

If you have a relationship set up between the tables based on a common key with delete cascade set to true then it will happen automatically for you.

Hope this helps!

 

[makala]

Will this work if the corresponding circuit and Patch records are on two different tables. Rack and Patch are on one and Rack and circuit are on another.

 

[WantsToLearn]

Yes. In the relationsships window, right click on the line connecting the tables and look at the options. As an example if you had invoice detail lines with a relationship into invoices which in turn had a relationshiop into customers and all of the relationships were set up to Cascade Delete then deleting a customer would automatically delete all of their invoice and invoice detail records as well.