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

references
(Greg Huston) #1

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) #2

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) #3

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

(Aleksi Alkio) #4

I tested it and it was working.