Is it possible when deleting a row, to delete...

[Greg_Huston]

Is it possible when deleting a row, to delete all items that are REF dependant on that row?

For example - making a timesheet app. Two tables, one is the timesheets with

TimesheetID, Owner, Date, Status, Total Hours, and the next table is LineItems with Job numbers, customers, hours, work codes.

Each time sheet has multiple line Items. So I’ll have today’s time sheet, but it (REF) references multiple lines in the lineItems spreadsheet. If I delete the Timesheet, those line items now point (REF) to a timesheetID that doesn’t exist. Can I somehow make a delete that delete’s the timesheet, and the inline data for it?

Thanks!

[Aleksi_Alkio]

Yes it should be possible already. If you choose the option IsAPartOf to TRUE, it should delete all your related records as well.

[Grant_Stead]

Is that feature live? I wasn’t aware it was available yet…

[Aleksi_Alkio]

I tested it and it was working.