You’re offline. This is a read only version of the page.
35
Hi everyone,
I need to fill the Name field when I select a vendor ID
How I can do it
thanks
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.
Hi, I have mentioned several simple solutions in the following post, hoping to give you some hints.
Thanks.
ZHU
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.
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
Share
Report
All responses (
Answers (
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
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
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,253
Super User 2024 Season 2
#2
Martin Dráb
230,188
Most Valuable Professional
#3
nmaenpaa
101,156