The ProBindingSource Designer dialog allows you to define recursive relationship between tables using the Recursive table property field. When defining a recursive relationship, note of the following:

  • Recursive table lists the name of the selected table and all its parent tables in a hierarchical order.
  • A table can have a recursive relationship with either itself or with any of the parent table in its hierarchy.
  • You can define only one recursive relationship in a schema definition.

To define a recursive relationship using the ProBindingSource Designer:

  1. If the ProBindingSource Designer is not already open, right-click on bindingSource1 and choose ProBindingSource Designer.
  2. In the Tables pane, select esalesrep. The Recursive table drop-down in the properties pane lists the esalesrep and ecustomer tables.
  3. Do one of the following:
    • Select ecustomer table from the Recursive table drop-down, if you want to define a recursive relationship between the esalesrep and ecustomer tables.
    • Select esalesrep from the Recursive table drop-down, if you want to define a recursive relationship with the esalesrep table itself.
    Note: If a recursive relationship already exists for the selected schema definition, a message displays stating: "recursive relation already exists".

    The ProBindingSource Designer dialog looks similar to the following illustration:



  4. Click OK to save changes to your schema definition.