Hello John,

I checked out your page. You'll need to work with JavaScript.
Check out this link:

http://javascript.internet.com/forms/dropdown-box-population.html

Luck

David

>Hi all,
>
>I've got a workable catalog on our site, but need to make some changes before finalizing it. I've been searching the 'Net for tutorials, message boards, etc., but am not getting the answers I need. I'm hoping someone here can help me finish it off.
>
>The way it is now:
>
> - I enter a Manufacturer (for example: PONTIAC)
>
> - I enter a Model (for example: FIREBIRD)
>
>And the page returns the listings for Pontiac Firebird. That's just fine, and was done with the FrontPage database wizard. But it needs some fine-tuning...
>
>The way I want it to be:
>
> - The page creates a dropdown menu by searching the catalog.dbf for all manufacturers (select distinct mfg from catalog)
>
> - The user chooses one of those manufacturers from the dropdown list (for example: PONTIAC)
>
> - The page creates a second dropdown menu by searching the catalog.dbf for all models made by that manufacturer (select distinct model from catalog where catalog.mfg=mfg
>
> - The user chooses one of those models from the second dropdown list (for example: FIREBIRD)
>
>And the page returns the listings for Pontiac Firebird.
>
>I'm just not seeing how to populate the dropdown lists from my DBF file. I'm using a file called "catalog.dbf" which is on my server in the same folder as "catalog.asp").
>
>Here it is in case looking at it would help you to understand me better:
>
>http://www.union-spring.com/catalog.asp
>
>Can you point me in the right direction or tell me what I need to do to finish this up? I'm VERY new to this ASP stuff.
>
>Thanks!
>
>John