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
Is it possible to access vehicle table from registrations view?
Thanks in advance!!