Table linking question

[Vedran]

Hello!!

I have two tables in the database: registrations and vehicles. Vehicles
contains types of vehicles. I would like to put in the registrations
view a drop down list (i think it is called select) that lists all the
vehicle types (eg. SUV, Convertible...) from the vehicle table. Also
after a user chooses a vehicle type, id of this vehicle should be
written as a foreign key in the registrations table.

I would appreciate if someone would give me some guidelines how to do that.

Is it possible to access vehicle table from registrations view?

Thanks in advance!!