Narrowing down a value list
I am doing a car dealership database for a school project.
When entering the details of a new car into the system, i wish to be able to narrow down the amount of models, when i have entered the make.
For example, if i enter in that the car is a Toyota, is there a way to automatically make it only show a drop down list with Corolla, Ascent, RAV4, Prius, Camry etc. (i.e. all the models of Toyota).
Can someone please explain to me how to do this?
Thanks very much