Defining a recursive relation between tables

To define a recursive relation between tables:
  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.