making a query

[Rosflurg]

I am making a database and i have a dropdown list in my table, in this list
are values of another table. based on the value selected in this list i want
to change the values of the next dropdown list.

example:
when the first dropdown list contains : Audi | BMW | Ford
I want the next dropdown list to display only the models of the selected car.

I just have problems creating the needed query.

The Table with the manufacturers is named Brands and the needed column Brand
The table with the models is named Model and contains column Brand and
column Model
I need the model to be displayed in table Cars in column Model. but i need
to use the value from the Brand column in table Cars to do so.

How do i make a query for this?

 

[Brendan Reynolds]

You can't do that kind of thing at the table level. You need to use forms
for that. There's an example at the following URL showing how to do it in a
form ...

http://www.mvps.org/access/forms/frm0028.htm