View Single Post
  #3 (permalink)  
Old June 29th, 2009, 06:37 PM
slake slake is offline
Authorized User
 
Join Date: Jun 2009
Posts: 13
Thanks: 2
Thanked 0 Times in 0 Posts
Default Foreign key conatraint in database

Hi
I have 2 tables connected to each other and when i try to insert data int them from a vb form the foreign key relationship wont hold. Their respective primary keys are identity columns .
when data is inserted in the vb form the primary keys for both tables are generated.Foreign keys wont show.
I have created a data table with all the columns defined as well as the foreign key constraints but still nothing happens.

If anyone has dealt with a similar problem please advice as im reallly desperate to get this working and dont know what to do.

Please provide any code examples you might have as im new at dealing with programs and posting to forums.

Thanks in advance
Reply With Quote