View Single Post
  #2 (permalink)  
Old January 7th, 2007, 05:17 PM
code_lover code_lover is offline
Authorized User
Join Date: Jan 2007
Location: , , .
Posts: 46
Thanks: 2
Thanked 1 Time in 1 Post

Now as far as i can see you have a parent child relationship between the two tables.The Student table is the master table and the StudentSchedules table is the detail table(1:M relationship).
We do not usually come up with a scenario in this case where we have to insert data into 2 tables simultaneously.Now will you just specify what really you want to insert into tables.Can you just explain in more detail what are you trying to achieve?
If you just want to populate the 2 tables , you really need to execute 2 separate INSERT statements in SQL to do that to the best of my knowledge.

Reply With Quote