Results 1 to 3 of 3
  1. #1
    Join Date
    Nov 2003
    Location
    Queensland
    Posts
    17

    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

  2. #2
    Join Date
    Nov 2003
    Posts
    267
    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.

    S-

  3. #3
    Join Date
    Nov 2003
    Location
    Queensland
    Posts
    17

    Talking

    Thank you very much, all works fine now....just lost the plot for a while there.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •