Share
Report
5Hello all,
I'm trying to add a FlowField to the Job Ledger Entry table that looks up the Item # in the Item table where the Description values match. However I only want it to do this if the Description value in the Job Ledger Entry table is NOT blank. Below code gives you an idea of what I've been trying to do. Is it possible to add this condition in the lookup?
tableextension 60003 JobLedgerEntry extends "Job Ledger Entry"
{
fields
{
field(60000; "Part No. Ref."; Code[20])
{
FieldClass = FlowField;
CalcFormula = lookup("Item"."No." where(Description = field(Description), Description <> const('')));
}
}
}
All responses (
Answers (
