I did not create any SQL trigger or procedure before. What I need is that I three tables as:
1- Parent [Employee]: EmpID (PK), EmpName ...etc.
2- Child [EmpCourse]: EmpID (FK), CourseName, ...etc
3- Child [EmpExperience]: EmpID (FK), ExperienceSource, ...etc.
I need when Insert a new record im Employee at same time insert a new record using EmpID in the two childs.