Access and ASP

See more:

ASP

MS-Access

database

Hi there,

I have a database in access and it contains 10 tables.

I have managed to get a selected table to disply on a webpage using Visual Studio, the Access data source, and the Grid view.


in the grid view I have selected one out of the many tables I have. This displays without a problem

What I am looking to do now is to have the option for the user to select individual fields then the table will reflect the fields selected.

i.e

there is a table with 4 colomns.

1.Car make
2.Car model
3.Engine size
4.Car colour

I presume you will need to use the drop down list.

So in the ist dropdown list the user selects the car make. this will then inturn display all the cars of that make in the grid.

The user can then go on to select a car model, which inturn will select all the cars of that make and model.

the same goes for engine size and colour.

I would like the database to have this functionality for no matter what the select, i.e if they select the car colour first , the table will then show all the cars/makes/models/engine size of that colour.

What is the best way of doing this with access and asp.

Thank you