Inserting foreign keys

[twigboy]

Hi everyone,
I have a couple tables(Customer,Car, and Reservation). Each has its own primary key(CusId, CarId, ResId) and the Reservation table contains foreign keys CusId and CarId.
I have a Reservation form that asks for the customers first and last name,the customer should already be listed in the customer table, and what kind of car they want for the reservation.
My question is how do I find the CusId and CarId keys from the information on the form to insert into the Reservation table.


Thanks

[iburyak]

Hi everyone,
I have a couple tables(Customer,Car, and Reservation). Each has its own primary key(CusId, CarId, ResId) and the Reservation table contains foreign keys CusId and CarId.
I have a Reservation form that asks for the customers first and last name,the customer should already be listed in the customer table, and what kind of car they want for the reservation.
My question is how do I find the CusId and CarId keys from the information on the form to insert into the Reservation table.


Thanks

[PHP]DECLARE @CusID int, @CarID int

SELECT @CusID = CusID from Customer where FirstName = 'first_name here'
and LastName = 'last_name_here'

SELECT @CarID = CarID from Car where car = 'car_here'

INSERT INTO Reservation values (@CusID, @CarID, .......)[/PHP]

[twigboy]

awesome thanks.
Is this a stored procedure or can I just use the DECLARE keyword in the form code?

[PHP]DECLARE @CusID int, @CarID int

SELECT @CusID = CusID from Customer where FirstName = 'first_name here'
and LastName = 'last_name_here'

SELECT @CarID = CarID from Car where car = 'car_here'

INSERT INTO Reservation values (@CusID, @CarID, .......)[/PHP]

[iburyak]

Put it in a stored proc:


[PHP]Create proc ProcName
@FirstName varchar(50),
@LastName varchar(50),
@Car varchar(50)
AS

DECLARE @CusID int, @CarID int



SELECT @CusID = CusID from Customer where FirstName = @FirstName
and LastName = @LastName



SELECT @CarID = CarID from Car where car = @Car



INSERT INTO Reservation values (@CusID, @CarID, .......) [/PHP]