Page Extension | Allow user to choose field valuefrom a list

(1) Share

Report

Posted on by Community member

Hi,

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:

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:

Dynamics 365 Business Central

I have the same question (0)

All responses (1)

Answers (1)

Verified answer

YUN ZHU 95,681 Super User 2025 Season 2 on at

Like (0)

Report

Hi, there are several common solutions to this, hopefully the information below can give you some hints

How to create a Lookup, Drop-Down, or Option list (Single and Multi select)

https://yzhums.com/5985/

Thanks.

ZHU

Was this reply helpful? Yes No