foreign key concept

Hey!

Just take ref of this..
(it is for 2 table named submissions and submittedItems)

--populate tables with sample data
DECLARE @totalRecords int 
SET @totalRecords = 0
DECLARE @currentKey int


WHILE @totalRecords < 500
BEGIN
    SET @totalRecords = @totalRecords + 1


    INSERT INTO dbo.submissions (submissionName, dateSubmitted)
        VALUES ('submission record ' + cast(@totalRecords AS varchar(3)), SYSDATETIME())


    Set @currentKey = Scope_Identity()


    INSERT INTO dbo.submissionItems (fk_submission_id, item)
        VALUES (@currentKey, 'a new record item for submission '+ cast(@totalRecords AS varchar(3)))
END


All the best.

Actually foreign key primary key relationship will never do such automatic insertion  in one table to another table. For doing that you have to write your own code or implement some logic that will do it.
Best way to do this create a trigger that fire when data insert on your first table. For creating a trigger go through following link.

http://www.tech-recipes.com/rx/41414/sql-server-coding-the-after-insert-trigger-in-sql-server/


http://www.codeproject.com/Articles/25600/Triggers-SQL-Server