1. Open the ProBindingSource Designer by selecting the ProBindingSource control on the Design Canvas, click and then ProBindingSource Designer or double-clicking ProBindingSource control on the Design Canvas.
The ProBindingSource Designer dialog appears and displays the current schema definition.
2. In the Tables pane, select a table for which you want to define the recursive relation. The selected table is called the base table.
3. In the Properties pane, select a table from the Recursive table list box with which you want to define a recursive relation to the base table. You can do one of the following:
If you want to define a recursive relation with the base table itself, select the base table from the Recursive table list box.
If you want to define a recursive relation with any of its parent tables, select a parent table listed in a hierarchical order from the Recursive table list box.
Note: Recursive table lists the name of the base table and all its parent table in a hierarchical order. By default, no tables are defined as recursive.
4. If a recursive relation already exists for the selected schema definition, you will receive a warning message recursive relation already exists on the <table name>. Do one of the following:
To retain the existing recursive relation and cancel the new recursive relation, click No.
To override the existing recursive relation with the new defined recursive relation, click Yes.
5. To save the changes in the selected schema definition, click OK.
and then ProBindingSource Designer or double-clicking ProBindingSource control on the Design Canvas.
If you want to define a recursive relation with the base table itself, select the base table from the Recursive table list box.