Share
ReportHow to autofill a value in field from anothor table ??
You’re offline. This is a read only version of the page.
22
How to autofill a value in field from anothor table ??
Hi, There is no problem with the code provided by Roberto. You may have added it in the wrong place.
You can refer to some standard features, for example, on the sales order, when you select a customer, many values from the customer table are automatically populated on the order.
Hope this helps.
Thanks.
ZHU
In addition to the solution Roberto gave you you can also define a default value for a field in a table.
docs.microsoft.com/.../devenv-initvalue-property
And if it is data from another table you want to display. Using a flowdfield of type lookup also might be a good idea.
its not working
Hi,
If you want obtain a value from other table (as ie when you introduce a item in a purchase order line and fill in the description and price) you need AL Code, usually in OnValidate Trigger:
trigger OnValidate()
var
ItemRec : record Item;
begin
if itemRec.get("No.") then
description := itemRec.Description;
end;
I hope this would be usefull for you. Best regards,
Roberto Corella
what do you mean by autofill? On Open page or from any other trigger?
Thanks.
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,280
Super User 2024 Season 2
#2
Martin Dráb
230,235
Most Valuable Professional
#3
nmaenpaa
101,156
All responses (
Answers (