mardi 19 juillet 2016

Is there any way to automatically add a new row into a junction table in sql?

I have two tables, tbl_Interview and tbl_JobSeeker the relation between the two is many to many, the normalization rules require me to create a new table which I called tbl_Interview_JobSeeker with the other two tables primary keys, my question is: If the table tbl_Interview_JobSeeker is a junction table is there anyway when I create a new row in the tbl_Interview table to automatically create a new row in the junction table as well?

Aucun commentaire:

Enregistrer un commentaire