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.

comment 16xMD

Edit Summary

Opens the summary editor.

RELATIONS Table

Name

Description

(blank)

Row index.

Name

Relation 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.

Summary (hidden by default)

Optional XML code comment.

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.

ParentRow Property Name (hidden by default)

Typed child rows ParentRow property name.

ParentRowView Create Property (hidden by default)

When unchecking code generation for ParentRowView property will be omitted.

ParentRowView Property Name (hidden by default)

Child views ParentRowView property name.

ChildView Create Property (hidden by default)

When unchecking code generation for ChildView property will be omitted.

ChildView Property Name (hidden by default)

Parent views Childview 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.

ParentRowView Create Property

When unchecking code generation for ParentRowView property will be omitted.

ParentRowView Property Name

Child views ParentRowView property name.

ParentRowView Property Name Auto

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

ChildView Create Property

When unchecking code generation for ChildView property will be omitted.

ChildView Property Name

Parent views Childview property name.

ChildView Property Name Auto

When checked "ChildView Property Name" is inferred from "ChildView Property Name Format" (see Project/All Views), relation, parent and child table 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.