Hi all,
On the 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."));
}
}
}
Thanks in advance
