Operating system version
Description of the issue
I am having 4 tables i.e. Subjects, Group, Students and Marks. The subject table has one row for every subject (around 20 rows), the Group table has the details of groups and 5 subjects will assign to every group, the Student table will have the details of students. Every student has to be assigned to a group, while assigning the Group to a Student, automatically a scrip has to insert 5 rows in the Marks table according to the group assigned with the respective subjectsid and studentid has the primary key.
Please help me to code the Marks row insert script.