Relationships Tab

This tab allows you to configure the relationship between two data sources through a common attribute or field. The relationship thus established can be used to:

• Configure styles, labels, or tooltips using attributes from the target data source.

• Edit data from the target data source, a non-spatial data table for example, through forms associated with a map layer.

• Locate features from a non-spatial data table.

• Perform searches based on attributes from a non-spatial data table.

• Populate the value domain of an attribute or a form component.

To view this tab, you must have permission to modify the data source. Also, only target data sources for which you have the Modify permission will be available.

Only one relationship can be established between a data source and each target data source.

A data source can have multiple relationships with as many target data sources.

Relationships can be created between:

• Two spatial data sources (vector).

• Two non-spatial tabular data sources.

• A spatial data source and a non-spatial tabular data source.

• A non-spatial tabular data source and a spatial data source.

Creating a Relationship

1. Click + to display the relationship configuration interface.

2. Select the type of relationship to create: 1 to 1 or 1 to many.

   • A 1-to-1 relationship means that each record in the DS corresponds to a single record in the target DS.

   • A 1-to-many relationship means that each record in the DS can correspond to multiple records in the target DS. For example, an air quality monitoring station (current DS) can correspond to multiple contaminant concentration measurements at different times of day (target DS).

3. Select the target DS.

4. Select the attributes in both DS that allow the correspondence between the two sources.

5. Enter the prefix that will be added to the names of the attributes added to the DS.

6. Click Create. The relationship is displayed in the Relationships section of the tab.

Editing or Deleting a Relationship

In the Relationships section of the tab:

1. Click on the relationship to activate its editing. The relationship information becomes highlighted and the fields in the configuration interface become editable.

2. Once you have completed your edits, click Edit. The changes are saved.

3. When you hover over the relationship, the delete icon appears.

4. Click the delete icon. The relationship is removed from the tab.