Sorry about the vague question.
Managed to figure it all out thou
Coursework new_course_work = new Coursework();
new_course_work.Due_Date = this.dateTimePicker1.Value;
new_course_work.Title = this.textBox1.Text;
new_course_work.Module_Code = moduleList.GetItemText(moduleList.SelectedItem);
Globals.database.Courseworks.InsertOnSubmit(new_course_work);
Globals.database.SubmitChanges();
var query_ = from DataClasses1 in Globals.database.Enrols
where DataClasses1.Module_Code == new_course_work.Module_Code
select new {DataClasses1.Student_ID };
foreach (var item in query_)
{
Submission new_submission = new Submission();
new_submission.Bar_Ref_ID = Globals.Bar_Ref_Gen();
new_submission.CWRefID = new_course_work.CWRefID;
new_submission.Status = false;
new_submission.Student_ID = item.Student_ID;
Globals.database.Submissions.InsertOnSubmit(new_submission);
Globals.database.SubmitChanges();
Thats my code and it works fine. Incase any one with same problem could use mine to try and solve