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.

Any help on this one?

"Rosflurg" <(E-Mail Removed)> wrote in message
news:35B30567-7D60-4745-9EB7-(E-Mail Removed)...
>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.
>
> Any help on this one?

Just to get you started,

You need (at least 2) Tables:

Manufacturers
==========
ManufName
------
BMW
Ford
....
....

Models
ManufName Model
Ford Focus
Ford Mondeo
BWM 316
BMW 530
....
....


The First Dropdown list would be based on the Manufacuters Table.

The Second would be based on a query on the Models Table:

Select * from Models WHERE ManufName = ddlManufacturer.Text

Cheers,

Chris.

Search string in this group:

Link combo boxes

There is a lot of material there.


Rosflurg wrote:
> 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.
>
> Any help on this one?

Okay this helps a little.

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?

"ChrisM" wrote:

>
> "Rosflurg" <(E-Mail Removed)> wrote in message
> news:35B30567-7D60-4745-9EB7-(E-Mail Removed)...
> >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.
> >
> > Any help on this one?
>
> Just to get you started,
>
> You need (at least 2) Tables:
>
> Manufacturers
> ==========
> ManufName
> ------
> BMW
> Ford
> ....
> ....
>
> Models
> ManufName Model
> Ford Focus
> Ford Mondeo
> BWM 316
> BMW 530
> ....
> ....
>
>
> The First Dropdown list would be based on the Manufacuters Table.
>
> The Second would be based on a query on the Models Table:
>
> Select * from Models WHERE ManufName = ddlManufacturer.Text
>
> Cheers,
>
> Chris.
>
>
>