Insert ID into 2 linked tables

[osani]

HI,
I am very clumsy with vb.net and sql server, but I am trying to insert an id number into 2 tables that are linked. when I insert into one, it says I violated the foriegn key relationship with the other. How do I insert into both tables simultaneously using a sub routine in vb.net?

Thanks!!

 

[jmcilhinney]

You have to insert it into the parent table first. That way the foreign key exists when you insert into the child table.