To define a recursive relation between tables:
-
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. - In the Tables pane, select a table for which you want to define the recursive relation. The selected table is called the base table.
-
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. -
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.
- To save the changes in the selected schema definition, click OK.