Deleting parent deletes children

[Paul_Danyliuk]

Alternative way for those who prefer formulas: instead of deleting from another table where Meeting = thisRow, you can delete by references pulled via lookups:

RunActions(
  thisRow.Tasks.Filter(true).DeleteRows(),
  thisRow.Topics.Filter(true).DeleteRows(),
  thisRow.DeleteRows()
)

This is especially useful if the condition for the lookup is more than just something = thisRow.

Filter(true) is the trick to convert a list of rows into a “virtual” table that you can feed to DeleteRows(). Simply thisRow.Tasks.DeleteRows() won’t work. Props to @Dalmo_Mendonca for the trick:

Mark checkbox if certain options are selected from a list

I can’t seem to make that one work The buttons only work if there’s only a single row selected: Edit: Got it. Some functions like Filter() return a table, so you can use it to convert a list of rows into an anonymous table before applying ModifyRows: Still don’t know how your code would work for the original post, though.