Share
Report
54Hi,
This is a very basic question from a noob, but how do I get a list of data from another table that a user can choose?
I have a page extension that adds a field to the page. I want the user to click into the cell and have it open a list of items from another table, and when they choose an item it populates the field with that value.
This is a very basic question from a noob, but how do I get a list of data from another table that a user can choose?
I have a page extension that adds a field to the page. I want the user to click into the cell and have it open a list of items from another table, and when they choose an item it populates the field with that value.
fields
{
// Add changes to table fields here
field(60104; /Linked Counter/; Code[20])
{
Caption = 'Counter No.';
Editable = true;
}
}
If I add a lookup:
FieldClass = FlowField;
CalcFormula = lookup(/Table/./Field/);
I get the list, but it won't let me choose one to fill the box in with.
Ideally I want something like this:
Ideally I want something like this:
CalcFormula = lookup(/Table/./Field/ where(/Other field/ = const(/field value/)));
But I can't get the syntax right.
Any guidance you can give would be very helpful!
Categories:
All responses (
Answers (
