Open topic with navigation

Calendar: Form - Dependencies


A resource to allow to link related tables, defining a dependency between tables. For example, the table of orders and items, removing a record from the table of orders, all its items also have to be removed. See an example using this resource below.




1º- First define a new dependence. In this example we will create an dependency between adm_suppliers_products (Dependent table) with the table adm_supplier (Actual application). Click on the button new dependency to begin.


2º - Select the dependent table and inform the amount of fields related to the father and child table. In this example only one field is related : the supplier code.


3º - Select the keys (linking fields) : adm_suppliers -> supplierID - adm_suppliers_products ->supplierID.

4º - Click on the button generate Scripts to define the dependence rule.