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