The INSERT statement conflicted with the FOREIGN KEY constraint

The INSERT statement conflicted with the FOREIGN KEY constraint "FK_Student_Resource". The conflict occurred in database "DatabaseName", table "dbo.Resource", column 'ResourceId'.
The statement has been terminated.

USE [DatabaseName]
GO
/****** Object:  StoredProcedure [dbo].[insertupdatestudentdata]    Script Date: 04/13/2012 13:29:16 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
-- =============================================
-- Author:  <author,,name>
-- Create date: <create>
-- Description: <description,,>
-- =============================================





ALTER PROCEDURE [dbo].[insertupdatestudentdata] 
 -- Add the parameters for the stored procedure here
  @FirstName nvarchar(50),
  @LastName nvarchar(50),
  @UserName nvarchar(50),
  @Password nvarchar(50),
  @LevelId int,
  @TeamId int,
  @Active bit,
  @Flag char(1),
  @LastLoginDate datetime,
  @ClientId int,
 
  
  --@StudentId int,
  @StudentNumber int,
  @Address nvarchar(100),
  @Postcode nvarchar(20),
  @City nvarchar(30),
  @Phone nvarchar(20),
  @Mobile nvarchar(20),
  @EmailCompany nvarchar(30),
  @EmailPersonal nvarchar(30),
  @CreboId int,
  @FromYear nvarchar(10),
  @ToYear nvarchar(10),
  @ClassId int,
  @CoachId int,
  @CreatedBy int,
  @CreatedDate datetime,
  @ModifiedBy int,
  @ModifiedDate datetime,
  @Variant char(15),
  @CourseType nchar(3),
  @Remarks nvarchar(max),
  @ResetPassword int,
  @DefaultCompanyId int
 
AS
BEGIN
 -- SET NOCOUNT ON added to prevent extra result sets from
 -- interfering with SELECT statements.
 
 SET NOCOUNT ON;
  DECLARE @RetVal int;
 
      --SYTAX : exec myproc @a = @myvara out, @b = @myvarb out
      -- where @a is the variable where we store return value
      -- and @myvara is the out parameter  
      
 BEGIN TRAN insertStudentInfo

 EXEC insertresourceinfo @FirstName,@LastName,@UserName,@Password,@LevelId,@TeamId,@Active,@Flag,@LastLoginDate,@ClientId, @ResetPassword,
  @EmailPersonal,@CreatedBy,@CreatedDate,@ModifiedBy,@ModifiedDate,@DefaultCompanyId,@RetVal = @RetVal OUTPUT;
    
COMMIT TRAN insertStudentInfo;

--ALTER TABLE [DatabaseName].[dbo].[Resource] WITH NOCHECK add constraint [FK_Student_Resource] foreign key(ResourceId) references [SusanneDB].[dbo].[StudentDetails]
--on delete set null


 INSERT INTO [DatabaseName].[dbo].[StudentDetails]
   ([StudentId], [StudentNumber], [Address], [Postcode], [City], [Phone], [Mobile],
   [EmailCompany], [EmailPersonal], [CreboId], [FromYear], [ToYear], 
   [ClassId], [CoachId], [CreatedBy], [CreatedDate], [ModifiedBy], [ModifiedDate], [Variant], 
   [CourseType], [Remarks])
 VALUES
   (IDENT_CURRENT('Resource'),@StudentNumber, @Address,@Postcode, @City, @Phone, @Mobile, 
   @EmailCompany, @EmailPersonal, @CreboId, @FromYear , @ToYear, 
   @ClassId, @CoachId, @CreatedBy, @CreatedDate, @ModifiedBy, @ModifiedDate, @Variant, 
   @CourseType, @Remarks);
   
 SELECT @RetVal as studentid ,Email,Password FROM Resource WHERE ResourceId=@RetVal;
-- SELECT @RetVal as studentid;

END