NickBridgens
08-25-2003, 01:23 PM
Hi
Ive got an Access database with three tables - make, model and derivative. Each has a numeric key and description plus link to previous level. I'm trying to run a filter for a report in ASP. So I'm looking for a three level combo box linking to Access. Easy huh?
Can anyone help?
I tried this code :
http://www.asp101.com/articles/hierarchy/index.asp
but having linked it to my data, when I select the first item, it filters combo box 2 correctly but then shows record 1 in combo cox 1. Having selected from combo box 2, it filters 3 correctl but shows the default in combo 2. When it finishes it gives the right code for combo 3 but records 1 and 1 for boxes 1 and 2.
My code and database is attached...
What's it doing wrong?
Secondly, I'd ideally like to be able to "quit" at any point. The ultimate filter is by derivative, but we may want to filter just by model, or even make (i.e what Ford's did XX buy last year", or What Transit's do we have in stock).
Any suggestions please???
Nick Bridgns
Ive got an Access database with three tables - make, model and derivative. Each has a numeric key and description plus link to previous level. I'm trying to run a filter for a report in ASP. So I'm looking for a three level combo box linking to Access. Easy huh?
Can anyone help?
I tried this code :
http://www.asp101.com/articles/hierarchy/index.asp
but having linked it to my data, when I select the first item, it filters combo box 2 correctly but then shows record 1 in combo cox 1. Having selected from combo box 2, it filters 3 correctl but shows the default in combo 2. When it finishes it gives the right code for combo 3 but records 1 and 1 for boxes 1 and 2.
My code and database is attached...
What's it doing wrong?
Secondly, I'd ideally like to be able to "quit" at any point. The ultimate filter is by derivative, but we may want to filter just by model, or even make (i.e what Ford's did XX buy last year", or What Transit's do we have in stock).
Any suggestions please???
Nick Bridgns