The Foreign key is a sequence of individual assignments separated from each other by a semicolon. Each of these individual assignments looks like this: $foreignField=$primaryKey.

To define Foreign key, you must select the desired fields in the Foreign key tab of the Foreign key definition wizard. Select the fields from the Fields pane on the left and move them to the Foreign key pane on the right.

Figure 63.1. Foreign Key Definition Wizard (Foreign Key Tab)

When you switch to the Primary key tab, you will see that the selected foreign fields appeared in the Foreign key column of the Foreign key definition pane.

Figure 63.2. Foreign Key Definition Wizard (Primary Key Tab)

You only need to select some primary fields from the left pane and move them to the Primary key column of the Foreign key definition pane on the right.

Figure 63.3. Foreign Key Definition Wizard (Foreign and Primary Keys Assigned)

You must also define the default foreign key values (Default foreign key). This key is also a sequence of values of corresponding data types separated from each other by a semicolon. The number and data types must correspond to metadata of the foreign key.

If you want to define the default foreign key values, you need to click the Default foreign key attribute row and type the default values for all fields.

In older versions of CloverDX, you had to specify both the primary and the foreign keys using the Primary key and the Foreign key attributes, respectively. They had a form of a sequence of field names separated from each other by a semicolon. However, the use of Primary key is deprecated now.

Check list of customers for cities without our branch office.

List of customers

John Doe        | London
Lucy Brown      | Glasgow
Elisabeth Smith | Stratford-upon-Avon
...

List of cities with our branch office

Edinburgh
Glasgow
London
...