Create Link

Creates a link.

Permissions

Command Kind	Needed User Kind
Write	Admin, Sys

Parameters

Name	Type	Description	Required	Default	Values
Destination	string	Destination table of the link ([SourceTable]).	yes
Link	string	Name of the link ([Link]).	yes
Source	string	Source table of the link ([SourceTable]).	yes
Caption1	string	Caption 1	no
Caption2	string	Caption 2	no
Caption3	string	Caption 3	no
Caption4	string	Caption 4	no
Caption5	string	Caption 5	no
Caption6	string	Caption 6	no
Caption7	string	Caption 7	no
Caption8	string	Caption 8	no
Caption9	string	Caption 9	no
Caption10	string	Caption 10	no
Derivation	boolean	If 'True' the destination table is a subset of the source table. Any change in the source table changes the destination table. The destination table cannot be changed with commands like 'Set Records' or 'Update Records'. The default value is 'False'.	no	false
Field	array of string	Number or text field to be linked. ([SourceField].[DestinationField]).	no
Fixed	array of string	Copies only values from the source table with the 'fixed' item ([Dimension].[Item]). This is a kind of filter.	no
Sum	array of string	Builds the sum of the source dimension ([Dimension]). By default equal dimensions in source and destination table are mapped. With 'Sum' the dimension is not mapped but a sum is calculated.	no

Result

Name	Type	Description
Link	string	Name of the link.
Caption1	string	Caption 1
Caption2	string	Caption 2
Caption3	string	Caption 3
Caption4	string	Caption 4
Caption5	string	Caption 5
Caption6	string	Caption 6
Caption7	string	Caption 7
Caption8	string	Caption 8
Caption9	string	Caption 9
Caption10	string	Caption 10
Source	string	Source table of the link.
Destination	string	Destination table of the link.
Fields	integer	Number of the linked fields.
Derivation	boolean	If 'True' the destination table is a subset of the source table. Any change in the source table changes the destination table. The destination table cannot be changed with commands like 'Set Records' or 'Update Records'.

Code

CREATE LINK
DESTINATION=[string, Needed]
LINK=[string, Needed]
SOURCE=[string, Needed]
CAPTION1=[string]
CAPTION2=[string]
CAPTION3=[string]
CAPTION4=[string]
CAPTION5=[string]
CAPTION6=[string]
CAPTION7=[string]
CAPTION8=[string]
CAPTION9=[string]
CAPTION10=[string]
DERIVATION=[boolean, default=false]
FIELD=[string, Multiple]
FIXED=[string, Multiple]
SUM=[string, Multiple]