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
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
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
- 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
- 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