View Single Post
  #9 (permalink)  
Old July 1st, 2009, 06:00 PM
slake slake is offline
Authorized User
 
Join Date: Jun 2009
Posts: 13
Thanks: 2
Thanked 0 Times in 0 Posts
Default foreign key constraint in sql

Hi Peace
Thanks for the helpon breaking the tables down. That i have done but i still need to auto generate the foreign keys of these relationships automatically. In ms sql i manually insert them as the primary keys are auto generated. I tried to write an insert trigger which did not work as i expected though it auto generated the foreign key but after the original data was inserted.

Do you know how to resdolve this issue please. If so let me know.I will be so greatful

Kind Regards

Slake
Reply With Quote