For example, in a PRODUCT data file, the reference of the product must be unique: each record must correspond to a different product, identified by its reference.
To do so, the REFERENCE item must be defined as unique key.
Example: A SUPPLIER distributes several PRODUCTS, but each PRODUCT is associated with a single SUPPLIER.
To manage the referential integrity in this type of link, the unique identifier of SUPPLIER must be included in the PRODUCT data file (this operation is automatically performed in the data model editor).
The referential integrity is used to check that:
Example: An order can contain several products and each product can be used in several orders.
In this case, a relation file must be created. This file contains the unique key of each data file that must be linked (as well as other information if necessary).
The complex link becomes a set of shared links.
J'accepte les termes de la licence
All you have to do is configure your product as follows: