Hai Bhasker,

if suppose i ve the request_id FK column depends travel_request table.

create table travel_request

(

request_id int identity PK

)

create table onward_journey

(

onward_journey_id int identity,

request_id int FK references travel_request(request_id),

departuredate datetime,

from_place varchar(10),

to_place varchar(10),

travel_mode varchar(10)

)

depends on above critirea i made procedure like these

alter procedure Insert_Journey

(

@departuredate datetime,

@from_location varchar(50),

@to_location varchar(50),

@metro nvarchar(50),

@trans_all nvarchar(50),

@mode_of_travel nvarchar(50),

@seat_type nvarchar(50),

@no_of_days int,

@other_details varchar(50),

@status_id int,

@request int

)

as

BEGIN

DECLARE @MaxDate datetime

SELECT @MaxDate = MAX(DepartureDate) FROM onward_journey where request_id=IDENT_CURRENT ('travel_request')

IF(@MaxDate >= @departuredate)

begin

RAISERROR('Your error message for departuredate should be greater then maxdate',16,1)

RETURN

END

insert into onward_journey(departuredate,from_location,to_location,metro,trans_all,mode_of_travel,seat_type,no_of_days,other_details,status_id,request_id) values(@departuredate,@from_location,@to_location,@metro,@trans_all,@mode_of_travel,@seat_type,@no_of_days,@other_details,'2',IDENT_CURRENT ('travel_request'))

--set @request= IDENT_CURRENT ('travel_request')

--return @request

end

is these correct ah?

how to that?