Unanswered: Deleting Data in Multiple Tables Using a Form
I have 3 main tables, one with employee data, one with employee vehicle licences and one with employee training. What I am hoping to do is once I look up an employee with a form, I would like then be able to delete the data relating to that employee from all 3 tables so that employee's data is no longer in the database by clicking on a command button. All 3 tables have employee ID as the joining point. Ok I dont even know if this is possible but I would appreciate any help at all. Thanks
One reason option Setup relationships between the three tables, with the option: "Cascade Delete" selected. The when you delete the employee record in the employee table. All the other records relating to this employee will automatically be deleted.