This feature allows to link the tables that contain relationships, being the tables that contain dependencies, like the tables orders and order_details. This way it’s possible to delete a record in the table orders, all the details for that order will be deleted as well. Below you’ll see a practical example on this feature.
- Firstly, you’ll define a new dependency. In this example, we’ll create a dependency between the orders (Dependent Table) with the order_details (Current Application). Click on the button New Dependency to start.
Creating a new Dependency.
- Selecting a the dependent table you’ll inform the amount of fields that are related between the both tables. In this example, only one field will be related to the orders id.
Dependency Table configuration.
- Next, select the fields that link the Keys: order_details->Orderid - orders->Orderid.
Dependency Key Fields Configurations.
- Creating a Dependency relationship, you only need to set the rules that the application will use. To do this, just click on the button Generate Scripts to define the Dependency Rule.
Configurando as regras da dependência.