php lookup queries

[toxi]

Hi, I'm using phpmyadmin.

 

I'm trying to get a lookup query on my database. Can that be done using phpmyadmin or do I have to write down the SQL myself?

 

Would it involve creating a view and then attaching it to a table?

 

In my case, I want the user to select from a list of cars, so what i want it to do, is in the "bookings" table to display a list of "cars". Possibly something like a field called "SelectCar" where a drop down menu would appear and the user can just click on the vehicle of their choice.

 

thanks!