Click or drag to resize
CalculationWorks Logo
Relations

Add and edit relations.

RELATIONS

This section contains the following subsections.

Category Relations
RELATIONS Commands

Image

Command

Description

Bcf Add

Add Relation

Adds an entry to the RELATIONS table.

Bcf Delete 12

Delete Relation

Deletes selected rows from RELATIONS table.

Show GridlinesHS

Toggle Columns

Toggles column filter.

RELATIONS Table

Name

Description

(blank)

Row index.

Name

Relation name.

Parent Table (hidden by default)

Parent Table Name.

Child Table (hidden by default)

Child Table Name.

Delete Action (hidden by default)

Determines how to handle child rows when deleting parent row.

Update Action (hidden by default)

Determines how to handle child key values when updating parent key value.

GetChildRows Method Name (hidden by default)

Typed parent rows GetChildRows method name.

AddChildRow Method Name (hidden by default)

Typed parent rows AddChildRow method name.

ParentRow Property Name (hidden by default)

Typed child rows ParentRow property name.

RELATION Properties

Name

Description

Name

Relation name.

Parent Table

Parent Table Name.

Child Table

Child Table Name.

Delete Action

Determines how to handle child rows when deleting parent row.

Update Action

Determines how to handle child key values when updating parent key value.

GetChildRows Method Name

Typed parent rows GetChildRows method name.

GetChildRows Method Name Auto

When checked "GetChildRows Method Name" is inferred from "GetChildRows Method Name Format" (see Project/DataSet), relation, parent and child table name.

GetChildRows Method Modifier

Modifier of typed parent rows GetChildRows method.

AddChildRow Method Name

Typed parent rows AddChildRow method name.

AddChildRow Method Name Auto

When checked "AddChildRow Method Name" is inferred from "AddChildRow Method Name Format" (see Project/DataSet), relation, parent and child table name.

AddChildRow Method Modifier

Modifier of typed parent rows AddChildRow method.

ParentRow Property Name

Typed child rows ParentRow property name.

ParentRow Property Name Auto

When checked "ParentRow Property Name" is inferred from "ParentRow Property Name Format" (see Project/DataSet), relation, parent and child table name.

ParentRow Property Modifier

Modifier of typed child rows ParentRow property name.

RELATION COLUMNS

This section contains the following subsections.

Category Relation Columns
RELATION COLUMNS Commands

Image

Command

Description

Bcf Add

Add Column Pair

Adds an entry to the RELATION COLUMNS table.

Bcf Delete 12

Delete Column Pair

Deletes selected rows from RELATION COLUMNS table.

Show GridlinesHS

Toggle Columns

Toggles column filter.

RELATION COLUMNS Table

Name

Description

(blank)

Row index.

Parent Column

Key column in parent table.

Child Column

Key column in child table.

Summary (hidden by default)

Not used.