Hi
I want to show 2 fields from "Item Tracking Code" on my "Item Card" pages.
These 2 fields are: "SN Specific Tracking" and "Lot Specific Tracking".
for this I've created 2 fields on Item table and Item Card as follow
Item Table:
field(1; SerialNo; Boolean)
{
TableRelation = "Item Tracking Code"."SN Specific Tracking" WHERE(Code = FIELD("Item Tracking Code"));
ValidateTableRelation = true;
}
field(2; LotNo; Boolean)
{
TableRelation = "Item Tracking Code"."Lot Specific Tracking" WHERE(Code = FIELD("Item Tracking Code"));
ValidateTableRelation = true;
}
Item Card:
field(LotNo; LotNo)
{
ApplicationArea = All;
Visible = true;
}
field(SerialNo; SerialNo)
{
ApplicationArea = All;
Visible = true;
}
But when I run Item Card page and try to change the value. I get this error:
The following field must be included into the table's primary key: Field: Lot Specific Tracking Table: Item Tracking Code
