Hello all ,
"The following field must be included into the table's primary key: Field: Description Table: G/L Account Category."When adding the description in the respective field got error please find below screenshot
please see below my vs code
table 50105 CutBackTable
{
DataClassification = ToBeClassified;
fields
{
field(1; "Account Category Code"; Text[250])
{
DataClassification = CustomerContent;
TableRelation = "G/L Account Category".Description;
//TableRelation = "G/L Account Category".Description;
}
field(2; "Bill code"; Code[20])
{
DataClassification = CustomerContent;
//TableRelation = "Dimension Value".Code where ("Dimension Code" = field ("Bill code"));
TableRelation = "Dimension Value".Code;
//where ("Dimension Code" = field ("Bill code"), Code = field ("Control Account"));
}
field(3; "Control Account"; Code[20])
{
DataClassification = CustomerContent;
TableRelation = "G/L Account";
}
//field(4; "Percentage"; Decimal)
//{
//DecimalPlaces = 2 : 2;
//DataClassification = CustomerContent;
//OptionMembers =default;
// MinValue = 0;
//MaxValue = 100;
//}
field(4; "Percentage"; Option)
{
//DataClassification = ToBeClassified;
Caption = 'Percentage';
OptionMembers = " ","Working Interest","Paying Interest","Revenue – Cost Oil","Revenue – Profit Oil";
}
//field(id; MyField; Option)
//{
// DataClassification = ToBeClassified;
// OptionMembers =
//}
}
keys
{
key(PK; "Bill code")
{
//Clustered = true;
}
}
}
have any solution for this
