Open topic with navigation

DEPENDENCIES

This resource allows to associate tables, it means tables that exist dependences, such as the tables: orders and items. It is possible to remove a register from the Orders table and all its items. Lets see how to do it.

 

1 - First we must define a new dependence. In this example we will create a dependency between Orders (Dependent table) and the table Customer (Current application). Click on the button new dependency.

 

2º - We must select the dependent table and inform the amount of fields related between the father and child table. In this example only one field will be related that it is the customer id.

 

3º - Then we must select the key fields: customers -> CustomerID - orders ->CustomerID.

4º - Now we just need to define if it will just show an error message or it will make a cascade delete.