Recursion in Hierarchy

[Henners]

I have been scouring the net for information on preventing recursion in a hierarchy. We have a parent child structure to our objects. But I want to confirm that an object is not added to the same branch in the tree twice.

This may not be very clear, but if anyone has any ideas we can discuss this further.

 

[rajeevnandanmishra]

Hi there,
If you can give some table structue specifying which is parent and child columns, may we can see it.