Skip to main content

Notifications

Announcements

No record found.

Business Central forum
Answered

Page Extension | Allow user to choose field valuefrom a list

Posted on by 54
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:
  • Verified answer
    YUN ZHU Profile Picture
    YUN ZHU 63,857 Super User on at
    Page Extension | Allow user to choose field valuefrom a list
    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)
     
     
    Thanks.
    ZHU

Helpful resources

Quick Links

Replay now available! Dynamics 365 Community Call (CRM Edition)

Catch up on the first D365 Community Call held on 7/10

Community Spotlight of the Month

Kudos to Saurav Dhyani!

Congratulations to the June Top 10 community leaders!

These stars go above and beyond . . .

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 287,696 Super User

#2
Martin Dráb Profile Picture

Martin Dráb 225,490 Super User

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans