# Deleting rows from multiple related tables

**URL:** <https://community.glideapps.com/t/deleting-rows-from-multiple-related-tables/59594>\
**Category:** Ask for Help\
**Created:** [March 23, 2023, 5:18pm UTC](https://community.glideapps.com/t/deleting-rows-from-multiple-related-tables/59594 "2023-03-23T17:18:48Z")\
**Posts on this page:** 9\
**Page:** 1

<div class="post-metadata">

**Author:** ![s1mple](https://avatars.discourse-cdn.com/v4/letter/s/ac91a4/32.png) [@s1mple](https://community.glideapps.com/u/s1mple)\
**Post date:** [March 23, 2023, 5:18pm UTC](https://community.glideapps.com/t/deleting-rows-from-multiple-related-tables/59594/1 "2023-03-23T17:18:48Z")

</div>

I have 3 tables related to each other and I am looking for the best way to delete rows from all of them with one action.

Should I use the native Glide actions or a 3rd party app like Make that works with the Glide API?

---

<div class="post-metadata">

**Author:** ![Jeff\_Hager](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jeff_hager/32/43_2.png) [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)\
**Post date:** [March 23, 2023, 5:54pm UTC](https://community.glideapps.com/t/deleting-rows-from-multiple-related-tables/59594/2 "2023-03-23T17:54:18Z")

</div>

You can delete rows through a relation. If you have a table related to two other tables, you can set up a custom action with 3 action. The first two actions should delete rows in the related tables through the relation. Then the third action can delete the row in the main table.

---

<div class="post-metadata">

**Author:** ![s1mple](https://avatars.discourse-cdn.com/v4/letter/s/ac91a4/32.png) [@s1mple](https://community.glideapps.com/u/s1mple)\
**Post date:** [March 23, 2023, 6:05pm UTC](https://community.glideapps.com/t/deleting-rows-from-multiple-related-tables/59594/3 "2023-03-23T18:05:02Z")

</div>

I’m doing it exactly how you describe it. When I set the delete row action through relation I get a performance warning. What I’m asking is if this is the right way. I actually haven’t noticed slow loading etc.

---

<div class="post-metadata">

**Author:** ![Jeff\_Hager](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jeff_hager/32/43_2.png) [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)\
**Post date:** [March 23, 2023, 6:40pm UTC](https://community.glideapps.com/t/deleting-rows-from-multiple-related-tables/59594/4 "2023-03-23T18:40:32Z")

</div>

That’s the way I would do it. Don’t know if a suitable alternative.

---

<div class="post-metadata">

**Author:** ![s1mple](https://avatars.discourse-cdn.com/v4/letter/s/ac91a4/32.png) [@s1mple](https://community.glideapps.com/u/s1mple)\
**Post date:** [March 23, 2023, 6:43pm UTC](https://community.glideapps.com/t/deleting-rows-from-multiple-related-tables/59594/5 "2023-03-23T18:43:28Z")

</div>

It’s good enough for me. Thanks a lot.

---

<div class="post-metadata">

**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\
**Post date:** [March 24, 2023, 6:53am UTC](https://community.glideapps.com/t/deleting-rows-from-multiple-related-tables/59594/6 "2023-03-24T06:53:19Z")

</div>

> [@s1mple](#):
>
> When I set the delete row action through relation I get a performance warning.

What exactly does that warning say?  
Are you deleting through a single or a multiple relation?

---

<div class="post-metadata">

**Author:** ![s1mple](https://avatars.discourse-cdn.com/v4/letter/s/ac91a4/32.png) [@s1mple](https://community.glideapps.com/u/s1mple)\
**Post date:** [March 24, 2023, 7:41am UTC](https://community.glideapps.com/t/deleting-rows-from-multiple-related-tables/59594/7 "2023-03-24T07:41:13Z")

</div>

I’m using multiple relations.

Here’s the message I get:

> Watch out!
> 
> This action can delete multiple rows from table “Companies”. Deleting many rows at once can take long to process and may hold up other actions from being processed.

---

<div class="post-metadata">

**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\
**Post date:** [March 24, 2023, 7:54am UTC](https://community.glideapps.com/t/deleting-rows-from-multiple-related-tables/59594/8 "2023-03-24T07:54:41Z")

</div>

Okay, that makes sense.  
The warning comes because when you delete rows via a multiple relation, then _ALL_ matching rows will be deleted. Which in some cases could be thousands of rows.  
Is that actually your intention?  
If you’re just wanting to delete a single row, then you should do it via a single relation.

---

<div class="post-metadata">

**Author:** ![s1mple](https://avatars.discourse-cdn.com/v4/letter/s/ac91a4/32.png) [@s1mple](https://community.glideapps.com/u/s1mple)\
**Post date:** [March 24, 2023, 8:13am UTC](https://community.glideapps.com/t/deleting-rows-from-multiple-related-tables/59594/9 "2023-03-24T08:13:37Z")

</div>

That’s correct. I’m deleting multiple rows via multiple relations.
