Navigating a Relationship Using Two Approaches
After you know the direction of navigation that you want to follow, you can choose between two different approaches to implement the navigation.
You can navigate directly through a relationship collection using the IRelationshipCol interface, or you can use a specialized collection that is designed to simplify navigation. This specialized collection is a target object collection. You instantiate an object collection using the ITargetObjCol interface.
The following figure shows two different approaches for navigating the same path. In this example, the navigation moves from the Table object to a Column object.
In this figure, you can navigate through the Relationship collection (a two-step approach) or through the Columns collection (a one-step approach). Instantiating the Columns collection through ITargetObjectCol makes this collection a target object collection.