Display Vendor Name when I choose the vendor ID

(0) Share

Report

Posted on by company1

Hi everyone,

I need to fill the Name field when I select a vendor ID

How I can do it

thanks

Categories:

Dynamics 365 Business Central

I have the same question (0)

All responses (5)

Answers (3)

Suggested answer

Mohana Yadav 60,993 Super User 2025 Season 2 on at

Like (1)

Report

You can make the Name field as flowfield to show the name based on the Vendor No.

Or you can write code in OnValidate trigger of Vendor No. field to get the vendor record and assign Name

Was this reply helpful? Yes No
Verified answer

Govinda Kumar 2,304 Moderator on at

Like (2)

Report
Hi company1,

You have two options to achieve this. You can either add your logic to the OnValidate() trigger of VendorID field on the page level, or you can create a method in your table which gets the vendor name using the vendor ID, here is the code for the method
procedure displayVendorName(): Text var vendTable: Record Vendor; begin if vendTable.Get(Rec.VendorID) then begin exit(vendTable.Name); end; end;

Then, you use the displayVendorName() method in the page field as follows

field(VendorID; Rec.VendorID) { ApplicationArea = All; } field(PartcipantName; Rec.displayVendorName()) { ApplicationArea = All; }

I hope this helps, let me know if you have any queries.

Regards

Was this reply helpful? Yes No
Suggested answer

Inge M. Bruvik 1,105 Moderator on at

Like (0)

Report

Is your page based on the standard vendor table or have you created your own table.

If you have created your own table you can add a flow field to your table with the type LookUp.

That will display the vendor name in the table even if it is not stored in your table.

learn.microsoft.com/.../devenv-flowfields

Was this reply helpful? Yes No
Verified answer

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

Like (1)

Report

Hi, I have mentioned several simple solutions in the following post, hoping to give you some hints.

https://yzhums.com/22220/

Thanks.

ZHU

Was this reply helpful? Yes No
Verified answer

Deekshitha Reddy 219 on at

Like (0)

Report

I have used 2 tables here, So in the second table's card were I wanted to display name when id is entered. Write the code on trigger ONVALIDATE of id field.

field(1; studentid; Code[50])//Second Table

{

DataClassification = ToBeClassified;

trigger OnValidate()

var

s1: Record Studenttable//variable of type record, from first table from where I am getting name(details)

begin

IF s1.Get(studentid) then

student_name := s1.studentname;

end;

field(2; student_name; Code[50])

{

DataClassification = ToBeClassified;

}

}

Hope this helps.

Was this reply helpful? Yes No