Im going to attach a picture to show you what i am trying to do.

 

Ok, now i am using the report control as a treeview. This is what i basically need to do:

X-Treme Console (Master Product)
        - Pioneer CDJ 1000 < Child

        - Pioner DJM 600 Mixer < Child
        - Technics SL1200 MK 11 Turntables  < Child

IF i put a tick in the parent record i can loop through the children and automatically check them (i have done this), BUT if i untick one of the child that should automatically untick the parent record (in other words if one of those products isn't present then the item is not whole so it becomes invalid).

So basically how do i loop through the child records and if one is unticked, untick the parent record also, else if all the children are all ticked the parent remains ticked too.

 

This is the final part of my project before rollout so PLEASE PLEASE someone help me :(

Thanks in advance