Share via


RELATION Function (FieldRef)

Finds the table relationship of a given field.

Syntax

  
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.
  
SaleRecref.OPEN(37);  
MyFieldRef := SaleRecref.FIELD(2);  
varRelation := MyFieldRef.RELATION;  
MESSAGE(Text000, varRelation);  

See Also

FieldRef Data Type