Help

How can I delete rows in linked tables?

Topic Labels: Base design
Solved
Jump to Solution
2155 2
cancel
Showing results for 
Search instead for 
Did you mean: 
111147
4 - Data Explorer
4 - Data Explorer

Hello!

I have 2 tables - “product” and “supplier”

These tables are related: in the table “product” I see the supplier, in the table “supplier” I see what goods he has.

When I am in the “supplier” table and click delete product, only the relationship between the tables is deleted. There are no changes to the “product” table.

How to make it possible to remove goods from the table “supplier”? To remove not only the relationship between the tables, but also goods from the “product” table.

1 Solution

Accepted Solutions
ScottWorld
18 - Pluto
18 - Pluto

Airtable does not give any automatic way to delete linked records upon removing a link. It would be a very nice feature to have in Airtable. Other database languages such as FileMaker give the option of deleting linked records automatically. You may want to add this as a product suggestion in the #show-and-tell:product-suggestions topic.

Most people manually delete those “orphaned records” from time-to-time during a cleanup process. You can create an additional view in that linked table that is filtered to show you only the records that don’t have any active links. Then you can just select all those records and delete them.

Otherwise, you can probably create a JavaScript to do this, but you’d manually need to run the JavaScript as well.

Hope this helps! If this answers your question, could you please mark this comment as the solution to your question? This will help other people who have a similar question. :slightly_smiling_face:

See Solution in Thread

2 Replies 2
ScottWorld
18 - Pluto
18 - Pluto

Airtable does not give any automatic way to delete linked records upon removing a link. It would be a very nice feature to have in Airtable. Other database languages such as FileMaker give the option of deleting linked records automatically. You may want to add this as a product suggestion in the #show-and-tell:product-suggestions topic.

Most people manually delete those “orphaned records” from time-to-time during a cleanup process. You can create an additional view in that linked table that is filtered to show you only the records that don’t have any active links. Then you can just select all those records and delete them.

Otherwise, you can probably create a JavaScript to do this, but you’d manually need to run the JavaScript as well.

Hope this helps! If this answers your question, could you please mark this comment as the solution to your question? This will help other people who have a similar question. :slightly_smiling_face:

Thank you, this method will mostly solve my problem!