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!!