Creating Relations: The Relation Wizard

When creating a new relation, a Relation Wizard will be started to guide you safely through the whole process. Using the Relation Wizard is the only way to create a new relation in the Relation Customizer. If you want to edit any of the existing relations, the relation will be opened in the Editor, which is the only tool for the modification of relations.

The Relation Wizard facilitates the following processes:

• Creating a relation of any type (many-to-one, one-to-many, one-to-one, many-to-many, transient or time related).
• Assisting the customizer by offering a logical sequence of steps where most of the values are already pre-filled.
• Generating the DDL script (that adds a foreign key or a new link table and foreign key constraints) and letting the user to execute it and save it to a file.

• Creating a relation in several easy steps without the need to switch to a DB tool or to the Object Type Customizer.

Note: The number of pages which the wizard consist of largely depends on the type of relation being created. For instance, creating a transient relation requires less steps than creating an m:n relation.

To start the Relation Wizard:

1. Start the Customization Browser.
2. Go to the 'Relations' tab and click the 'Create' button to start creating a new relation.
3. The Relation Wizard will be launched on the 1st page.

There are two examples of the wizard application in this chapter:

• Creating an n:1 (1:n) relation

• Creating an m:n relation

Note: The Relation Wizard covers every use-case of the process and type of the relation creation.