Viewing and editing the data model

Select + Add table. The Add table dialog is displayed.

Select the table that defines the new output table.

Select the Primary key for the new table, and select Done.

Select the table that you want to relate to another table.

The Edit table panel is displayed.

In the Edit table panel, select + Add new to create a new relation.

Select the field that you want to use in this table from the Key list.

Select the Table you want to connect to and select the field that use to connect from the Key list.

Select Apply.

Select the table for which you want to change the key.

The Edit table panel is displayed.

In the Edit table panel, locate the relation for which you want to change the key.

Select the new field that is to be used as the Key to join the tables.

Select Apply.

Select the table for which you want to delete an outgoing relation.

The Edit table panel is displayed.

In the Edit table panel, locate the relation you want to delete and select Delete relation.

Select Apply.