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?