Hi, ASP is quite new to me. My problem's quite long-winded but here goes...

I have 3 tables: car, dealer and parts and these tables are related in the ACCESS db, running on a coldfusion server. I have all connections to the db made through the ASP document in dreamweaver.

Say i have multiple car names, but i choose Ford, i want it to display all the related info for the Ford car.

What i`m wanting to do, is use a dynamic drop-down menu with all the car names, then update the repeating region recordsets to display JUST the ford data on the one page. I need it to do this for each option in the drop-down. Any ideas how i would do this plz, i`m struggling with where to start. Preferably steps of how to do it in Dreamweaver not just code please as i won't undersand it <img src=../images/dmxzone/forum/icon_smile.gif border=0 align=middle>

Thanks,

Andyram2k.

I've got part way there... I've made a query in access that lists all the car names, with parts and stuff. All i need to do now is change the field Car_Name to a drop-down, so i could select Ford, then it would update the records. I hope i`m making sense.

It's ok now. i've solved it. Thanks anyway.