Hi
How to automatically get data to field. So I have table that have relations with other table. One table field filled by choosing number from list and other field called name should automatically fill by that number meaning.
Ty for help
*This post is locked for comments
Pleas use Get if you are using Primary key instead of setrange and findfirst.
Finally I solved my problem. Thanks for help everyone.
This is because you have deleted the field no. 20 which is Vendor Name and you are trying to save the changes with the synchronize schema option "Now - with validation". If you are using this table for testing purposes just save the changes with the synchronize schema option "Force".
if u have an access to the dynamics learning portal u can find the tutorial in the developer role courses ,
by the following name:
81067AE: Development Environment Introduction in Microsoft Dynamics NAV 2017 and Dynamics 365
Hi Kazys,
You can code using SETRANGE function.
assume table1 and table2
Here table1.no is the no selected from the list
So on the OnValidate trigger of the no add the below code
table2.RESET;
table2.SETRANGE(no,table1.no);
IF table2.FINDFIRST THEN
Name:= table2.name;
Hi,
Please send a screenshot of the error you got.
Is there any tutorial or something with flowfield becaus i get error when im trying to use it?
you can use flowfield or write code in onvalidate trigger of number field.
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
Share
Report
All responses (
Answers (