RANGEDLINK

Creates a ranged link between two tables.

Allows a link between two tables to be created using a pair of columns on the primary table which denotes a range, to a column in the secondary table. Lower value is the name of the column in Table 2 to be linked (lower range). Upper value is the name of the column in Table 2 to be linked (upper range). Many is the name of the column in Table 1 to be linked.

For example, the following parameters creates a link between two tables:

RANGEDLINK [Table_2].[Start_Date], [Table_2].[End_Date], [Table_1].[Trans_Date]

A Rangedlink instruction must have the following syntax:

Syntax

RANGEDLINK [Lower value] [Upper value] [Many]

Parameters

Lower value

Name of the column in Table 2 to be linked – lower range.

Upper value

Name of the column in Table 2 to be linked – upper range.

Many

Name of the column in Table 1 to be linked