Skip to content
Arthur van de Vondervoort edited this page Dec 14, 2024 · 2 revisions

The field with table relation should have at least the same length as the referenced field.

This rule validates that fields with a TableRelation have a datatype and minimum length that match the primary key (PK) field of the referenced table.

Example

field(1; "Customer No."; Code[10]) // The related field has length 20 (Customer."No.") which is longer than the current field length 10 (Customer No.)
{
    Caption = 'Customer No.';
    TableRelation = Customer."No.";
}
Clone this wiki locally