Hi
Im a sql newbie , and have created two tables with a foreign key
relationship.

How do i insert into these tables. If i insert into the primary table
will the foreign key field in the second table be automaticly updated
by ms sql server ?