Hai Hanshi,

i ve 3 tables .

users:

=========

create table users

(

user_id varchar(100) primary key,

username bvarchar(100),

password varchar(100),

designation varchar(10)

)

insert into users values('0002','ram','ramki@123','progrmmer')

insert into users values('0006','ra','rai@123','Accounts')

travel_request:

===========

create table travel_request

(

request_id int identity primary key,

user_id varchar(100) foreign key references users(user_id),

travel_purpose varchar(100),

tota_amount varchar(10)

)

when the users ram is logged and write travel purpose making request means

insert into users values('0002','visit other branch','12000')

now request_id=1

like if some other users logged means ve to captch the user_id.

onward_journey:

============

create table onward_journey

(

onward_journey_id int identity primary key,

request_id int foreign key references travel_request(request_id),

departuredate datetime,

from varchar(10),

to varchar(10),

no.of.days int

)

after enter the purpose here insert ll goes like thes

insert into onward_journey values('01-jul-2013','chennai','banglore','1') onward_joureny=1 but request_id=1

insert into onward_journey values('02-jul-2013','banglore','Hydrebad','1')

onward_joureny=2 but request_id=1

onward_journey may increase depends on insertion dates but request_id is constant depends on travel_request table.

My Requirements is:

===============

if the different may logged means to ve captch user_id insert into travel_request.

i ve to captch the request_id from the praticular user_id pass to onward_journey table

how to do that?