Don't know foreign key?

redarroweric · #1 (**permalink**) 01-15-07, 00:22

I have read many books and I think I am missing something.

How can I insert data in a table if I do not know the foreign key. I want to enter a new load in a trucking database. I know the shippers name although I do not know the ShipperId. Not sure how to write the query.

Loads
PK_LoadId
FK_ShipperId
PickUpDate
DeliverDate

SHIPPERS
PK_ShipperId
Name
Address
City
State

r937 · #2 (**permalink**) 01-15-07, 03:48

Quote:

Originally Posted by redarroweric

I know the shippers name although I do not know the ShipperId. Not sure how to write the query.

Code:

select PK_ShipperId
  from SHIPPERS
 where Name = 'Todd''s Shipping'

then use that value in the INSERT statement for the Loads table

healdem · #3 (**permalink**) 01-15-07, 04:23

that'd work.....

but can I ask how are you collecting this information and entering into the database?

If you do this through a form/data entry screen then you could set up a combo box that displays the Shipper Name to the user, but uses the ShipperID for the record.

have a look at using a combobox in what ever front end you are using.

redarroweric · #4 (**permalink**) 01-15-07, 08:32

I guess I was making it harder then it is.

Thank You.

Internet Services

Web Development

Digital Marketing

Consumer Tech