kopiering via stored procs

To begin with – i’m rather newbee with this...
Case is as follow:
I have three tables: projects, projectcontent and designareas

On creating a new project there should be a possibility for copying designareas and projectcontent from an existing project.
So far that work fine with the following StoredProc

I have an one to many relation between tbl_DesignAreas and tbl_Project_Content

PK tbl_DesignAreas.areaid
FK tbl_Project_Content.designarea

CREATE PROCEDURE [dbo].[appendAll]
@NEWProjektID int,
@OLDProjektID int,
@userid int
AS

INSERT INTO dbo.tbl_DesignAreas
(DesignArea, ProjectID, description, modultreeid, Fluid, Revision_by)
SELECT DesignArea, @NEWProjektID AS ProjectID, description, modultreeid, Fluid, @uid
FROM dbo.tbl_DesignAreas
WHERE (ProjectID = @OLDProjektID)

In table tbl_DesignAreas I have an autonumber: areaid

INSERT INTO dbo.tbl_Project_Content
(componentID, Category, Quantity, ProjectID, createdby, ModultreeID,designarea)
SELECT componentID, Category, Quantity, @NEWProjektID AS projectid, @uid as createdby, ModultreeID, designarea
FROM dbo.tbl_Project_Content
WHERE (ProjectID = @OLDProjektID)
GO
Now in the second part of the stored proc it copies the rows from tbl_project_content correct except that designarea is copied as is with it’s old values, and here I miss the relationship.
Is it possible to have the value designarea to correspond to the newly created (autonumber) id’s from the first part of the stored proc.

Sincerely Uffe