Small and medium business | Business Central, N...

page extension drop down on item card

(0) Share

Report

Posted on by Rajiv Sewsarran

Hi All,

Ive created a new table and page, which i populated with some data.

I then needed a field on the item card to link this data to the item.

This is populated with 3 columns , Pump ID ., description 1 and description 2

So i created a table extension and page extension.

It works fine , only issue im having is for the field on the item card (page ext) when i go to select from the dropdown list, i only see the Pump ID , i dont see the descripton

Screenshot-2023_2D00_05_2D00_03-at-11.30.16-PM.png

tableextension 90601 "Pump Sel" extends Item
{

    fields
    {
        field(90601; "Pump Sel"; code[20])
        {
            TableRelation = "Pump Selector"."Pump ID";
            Caption = 'Pump Selection';
        }
        field(90602; Description1; text[100])
        {
            TableRelation = "Pump Selector".Descritpion1;
            Caption = 'Description 1 ';
        }
        field(90603; Description2; text[100])
        {
            TableRelation = "Pump Selector".Descritpion2;
            Caption = 'Description 2';
        }
    }

}





pageextension 90601 PumpSel extends "Item Card"
{
    layout
    {
        addafter("VAT Bus. Posting Gr. (Price)")
        {
            field("Pump Selection"; Rec."Pump Sel")
            {
                ApplicationArea = all;
                Caption = 'Pump Selection';
            }
        }
    }
}

Any help would be greatly appreciated!

Thanks!

Categories:

Dynamics 365 Business Central

I have the same question (0)

All responses (6)

Answers (0)

Suggested answer

Nitin Verma 21,708 Moderator on at

Like (0)

Report

on New table you have created just add your List page to that table with property LookupPageID = "List page id; and then check

Was this reply helpful? Yes No
Rajiv Sewsarran 55 on at

Like (0)

Report

Hey thanks for your response.

I did that and the result is the same

Was this reply helpful? Yes No
Suggested answer

Nitin Verma 21,708 Moderator on at

Like (0)

Report

set Drilldownpageid property with same page too and then try. also share your code.

Was this reply helpful? Yes No
Rajiv Sewsarran 55 on at

Like (0)

Report

Same result - here's the updated table code

table 90600 "Pump Selector"

{

DataClassification = ToBeClassified;

LookupPageId = "Pump Selector";

DrillDownPageId = "Pump Selector";

fields

{

field(1; "Pump ID"; Code[20])

{

DataClassification = ToBeClassified;

}

field(2; Descritpion1; text[100])

{

DataClassification = ToBeClassified;

}

field(3; Descritpion2; text[100])

{

DataClassification = ToBeClassified;

}

}

keys

{

key(Key1; "Pump ID")

{

Clustered = true;

}

key(Key2; Descritpion1)

{

}

}

var

myInt: Integer;

trigger OnInsert()

begin

end;

trigger OnModify()

begin

end;

trigger OnDelete()

begin

end;

trigger OnRename()

begin

end;

}

Was this reply helpful? Yes No
Suggested answer

Nitin Verma 21,708 Moderator on at

Like (0)

Report
You can try to create fieldgroup in this table. Like this code you can put your fields what you want to see.

fieldgroups { fieldgroup(DropDown; "No.", Description, "Base Unit of Measure", "Unit Price") { } fieldgroup(Brick; "No.", Description, Inventory, "Unit Price", "Base Unit of Measure", "Description 2", Picture) { } }

Was this reply helpful? Yes No
Suggested answer

Govinda Kumar 2,304 Moderator on at

Like (0)

Report
Hi,

As Mr. Nitin Verma said above, you can add a fieldgroup to your table "Pump Selector" in order to display the description with ID.. I mean you can choose which fields you want to see in the lookup..

fieldgroups { fieldgroup(DropDown; "Pump ID", Descritpion1) { } }

Regards

Was this reply helpful? Yes No