Relationships

The Relationship Manager lets you define and visualize entity-relationship diagrams between tables (sheets) in your workbook.

Opening the Relationship Manager

Access it from the Database menu or the Navigation Panel under Relationships. The dialog shows a canvas on the left and a properties panel on the right.

Adding Tables to the Canvas

Click Add Table to place a sheet on the canvas. Each table box displays the sheet name and all its column headers. Drag table boxes to arrange them on the canvas for a clear diagram.

Creating a Relationship

To create a relationship, drag from a field in one table box to a field in another. A connection line is drawn between the two fields. You can also right-click on the canvas to add a relationship manually by selecting the source and destination table/field pairs.

Relationship Properties

Each relationship has the following attributes:

Property	Description
Source Table / Field	The "from" side of the relationship.
Target Table / Field	The "to" side of the relationship.
Cardinality	One-to-One, One-to-Many, or Many-to-Many.
Enforce Referential Integrity	When enabled, data operations respect the constraint.

Editing and Deleting

Click a relationship line on the canvas to select it and view or edit its properties in the side panel. Right-click a line for a context menu with options to edit or delete the relationship.

Usage by Other Features

Relationship definitions are used by the Visual Query Designer to suggest joins between tables and by the Navigation Panel to display a complete picture of your data model.