Hi, I have two tables: 1) employees table where every record is a unique employee and 2) an employee by year table, where the year and employee make up the unique key/record. However, say I want to delete an employee in the first table. Is there a way for Knack to automatically go ahead and delete all of that employee’s annual records in the second table?
Unfortunately Knack does not currently offer the ability to delete child records when the parent is deleted.
You may find the below videos of help.
Managing Cascading Deletes in Knack: Step-by-Step Tutorial!
Archive, Restore and Soft Delete - Knack Database
1 Like