Deleting rows from multiple related tables

Ask for Help
1

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?

2

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.

3

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.

4

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

2 Likes
5

Itā€™s good enough for me. Thanks a lot.

1 Like
6

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

7

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.

8

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.

9

Thatā€™s correct. Iā€™m deleting multiple rows via multiple relations.

1 Like