Hi everyone,
I need to fill the Name field when I select a vendor ID
How I can do it
thanks
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
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
André Arnaud de Cal... 291,391 Super User 2024 Season 2
Martin Dráb 230,445 Most Valuable Professional
nmaenpaa 101,156