asp.net insert into table from other two tables?

[ANA]

Is it possible if you have three tables like Subject(id_subject,name), Student(id_student,Sname) and Enrollment(id_e,id_subject,id_student), to insert the id_subject from subject and id_student from student into enrollment. All the ids are auto increment, user chooses subject and student that exists and the code does the insert into enrollment