How to inherit values in fields

isabtogumonisabtogumon Member Posts: 44
Hi all,
On Clients page I added three fields, field A is the main one, field B depends on field A and field C depends on field A and B, so if field A is empty if fields B and C have any value, it should be cleared automatically or if the selection of field B and C does not correspond to field A and they have information, it should also clear. Any advice to do that?

I created three tables for each field because they are different catalogs and added the main fields to Customer table as table extension
tableextension 50013 ExtCustomerSegment extends Customer
{
    fields
    {
        field(50000; "Segment No."; Code[20])
        {
            Caption = 'Segment No.';
            DataClassification = ToBeClassified;
            TableRelation = Segment."No.";
            ValidateTableRelation = true;
        }
        field(50001; "Subsegment No."; Code[20])
        {
            Caption = 'Subsegment No.';
            DataClassification = ToBeClassified;
            TableRelation = Subsegment."No." where("Segment No." = field("Segment No."));
            ValidateTableRelation = true;
        }
        field(50002; "Value No."; Code[20])
        {
            Caption = 'Value No.';
            DataClassification = ToBeClassified;
            TableRelation = tValue."No." where("Segment No." = field("Segment No."), "Subsegment No." = field("Subsegment No."));
        }
    }
}

Comments

Sign In or Register to comment.