Hi experts,
i work on Dynamics NAV 2009 R2, I have created a specific table "50007" that contains those fields "Resposible Id","Date" and "Asset N°." . And i created a form for this table.
Now i want to modify ( "Fixed Asset table" 5600 ) When i will add a new row in 50007 Table. i want modify Asset Asset No for Responsible.
thnx
*This post is locked for comments
Hi Tharanga,
As the Asset "No." is the Primary Key in the Fixed Asset table, perhaps the below code would be the best way:-
IF recFA.GET("Asset No.") THEN BEGIN // This will filter the Fixed Asset master to your
recFA.Responsible := "Resposible Id"; // assign the responsible person.
recFA.MODIFY; // finally modify the FA master table
END;
Best Regards,
MMV
As Suresh said I believe table primary key is the Responsible ID and that means one person can only responsible for a one Asset.
Let me go to the coding.
In the new table you need to define a record variable for the Fixed Asset (Data Type : Record)
Open the table in the design view and then go to Global Variables and then provide a name (recFA) for the variable and select the variable type as Record. Then from the SubType you need to select the Table Fixed Asset.
After that process is completed you need to go to the code level by pressing F9 key. Then go to the OnValidate trigger of the "Asset No." and write the below code.
recFA.RESET; recFA.SETFILTER(recFA."No.","Asset No."); // This will filter the Fixed Asset master to your record variable. IF recFA.FINDFIRST THEN BEGIN recFA.Responsible := "Resposible Id"; // assign the responsible person. recFA.MODIFY; // finally modify the FA master table END;
This code will get executed every time you do any modification to Asset N° column in your new table.
Hello, I believe in your new table Responsible ID is the key, so what you can do is add the code on the validate of Asset No. field in 50007 to get the Fixed Asset Record using GET statement and modify it.
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 (