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!
User | Count |
---|---|
38 | |
34 | |
27 | |
23 | |
17 |