combo box drop down search

[penfold1992]

As an example lets say I have a table listing some cars:

Car Make Car Model
Ford Fiesta
Ford Focus
Ford GT
Mercades C Class
Mercades E Class
Mercades A Class

im making a form with two combo drop downs with the ability to select car make or model.

Car Model is Unique so if the car model is entered, I will force the car Make into the other combo box

however, If i select "Mercades" for example in the car make, I would like the combo box of Car model to only be filled with the possible models that Mercades make.

Is this possible? (to search for the values available in Car Model based on the value entered in Car Make?)

Thanks in advanced

 

[Mihail]

This sound (for me) like a cycle.
If I don't misunderstand, then the answer is NO. This is not possible