Hello there,
I have extended the Job table with a 1 to many relationship like this:
tableextension 50071 JobExt extends Job
{
fields
{
field(50041; "FooNo."; Integer)
{
TableRelation = Foo."No.";
Caption = 'bla bla';
ValidateTableRelation = true;
}
}
}
pageextension 50171 JobCardExt extends "Job Card"
{
layout
{
addlast(General)
{
field("FooNo."; "FooNo.")
{
ApplicationArea = All;
ToolTip = 'bla bla';
}
}
}
}
This creates a field in the page that contains the FooNo. value, if i click on it the system default dropdown appears and I can change the value (not sure if "system default dropdown" is the correct name)
What I need to achieve is to keep this dropdown and display the Foo.Name field instead of the No. field
Is there a way of achieving this without adding Name as a pk in Foo?
Thanks in advance