Im using sq05
I have a set of table which goes to 5 levels of Transation ,
ex:
- Parent 1
- Parent 2(Child of Parent1)
- Parent 3(Child of Parent2)
- Parent 4(Child of Parent3)
- Child (Child of Parent4)
Each Tables have their Corresponding Primary key & foreign key Relationships,
What Happens is when i tried to Delete a Parent2 Record the Corresponding Child Records of Parent2 and in turn all the Corresponding records of Parent3 should be Deleted ,
Is their any Query to Satisfy this Condition.
Kindly provide me with a valid Solution
Thanks in Advance !!