Finds the table relationship of a given field.

TableNumber := FieldRef.RELATION

Parameters

FieldRef

Type: FieldRef

The FieldRef that refers to the field for which you want to find the table relationship.

Property Value/Return Value

Type: Integer

The number of the table that has a relationship with the field referred to by FieldRef.

This relationship is set up through the properties.

Remarks

You can use this function for several purposes such as to determine lookups or to check to see if you have permission to read from a table.

This function is similar to the RELATION Function (Record) function.

Example

The following example opens table 37, the Sales Line table, as a RecordRef variable and creates a reference to field 2 (Sell-to Customer No.). The FieldRef Data Type of field 2 is stored in the MyFieldRef variable. The RELATION function retrieves the number of the table that has a relation with the Sell-To-Customer field (field 2). The table number is stored the varRelation variable and displayed in the message box. This example requires that you create the following variables and text constant in the C/AL Globals windows.

Variable name DataType

SaleRecref

RecordRef

MyFieldRef

FieldRef

varRelation

Integer

Text constant ENU value

Text000

Field 2 in the Sales Line (37) table has a relation with table %1.

Copy Code
SaleRecref.OPEN(37);
MyFieldRef := SaleRecref.FIELD(2);
varRelation := MyFieldRef.RELATION;
MESSAGE(Text000, varRelation);

See Also