Announcements
No record found.
Hi,
Im having two tables named Student Information , Student Marks . The Student Information table has two fields , Student Name and Rollno , the Student Marks table contains two fields Rollno and marks . If im Entering Roll no in Student information table the same roll no should be inserted in Student marks table . and also if im modifying the roll no in student infomation table it also updated in student marks table . i need x++ code for that . i am new to AX.
Thanks in Advance .
It looks like the same topic as what's already discussed in your other thread Inserting Data into Two Tables at same time by using Code.
Please check similar job
Student Information -> student Name, RollNo -> StudentInformation
Student Marks -> Roll no, marks -> StudentMarks
public static void main(Args _args)
{
StudentInformation student;
StudentMarks marks;
;
ttsbegin;
//Insertion of new record
student.clear();
student.rollNo = '1';
student.name = "Check";
student.insert();
select marks where
marks.rollNo == student.rollNo;
if(!marks)
marks.rollNo = '1';
marks.marks = '91';
marks.insert();
}
ttscommit;
//for updation
select forupdate student
where student.rollNo == '1';
student.rollNo = 20;
student.update();
update_recordset marks
setting roll = '20'
where roll = '1';
info("done");
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
Congratulations to our 2026 Super Stars!
We are thrilled to have these Champions in our Community!
These are the community rock stars!
Stay up to date on forum activity by subscribing.
Giorgio Bonacorsi 653
André Arnaud de Cal... 493 Super User 2026 Season 1
Syed Haris Shah 317 Super User 2026 Season 1
