Delete Parent and child using dreamweaver
Hi yea,
I have a parent table called boss and a child table called employee, One boss many employees in each department. If I delete a boss I want to delete all the employees too. lol Hi yea,
I have a parent table called boss and a child table called employee, One boss many employees in each department. If I delete a boss I want to delete all the employees too. lol ....SO I want an a tutorial on how to delete both from parent and all the children related to a primary key in the parent. It would be nice if this was in an access database.
The reason I need this is at the moment I have a subject in my data base and want to enter images regarding that subject, so I have 2 tables one with the subject details and the other with the images relating to that. where I am having difficulty is deleting, I.E if I want to delete the entire record of the subject and the child images relating to that subject.
Regards
Kenny
I have a parent table called boss and a child table called employee, One boss many employees in each department. If I delete a boss I want to delete all the employees too. lol Hi yea,
I have a parent table called boss and a child table called employee, One boss many employees in each department. If I delete a boss I want to delete all the employees too. lol ....SO I want an a tutorial on how to delete both from parent and all the children related to a primary key in the parent. It would be nice if this was in an access database.
The reason I need this is at the moment I have a subject in my data base and want to enter images regarding that subject, so I have 2 tables one with the subject details and the other with the images relating to that. where I am having difficulty is deleting, I.E if I want to delete the entire record of the subject and the child images relating to that subject.
Regards
Kenny
Comments
Be the first to write a comment
You must me logged in to write a comment.