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 resursive 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.
Recursive table lists the name of the selected table and all its parent tables in a hierarchical order.
