Hi, im really rusty in webdesign i havent touched in in a very long time ive been programming for years,

i have 2 dynamic menus
basicly
1 for car manufacture
and 1 more for modle of car

its really easy maybe cuz its the morning but, say when some one chooses Ford from the manufacture menu i want the modle menu to auto populate with all of the modles within the DB

my db is righten like
ford Focas | GT | Mustang | Topaz
Dodge RAM | Truck | BLAH | YEA

so i geuss the problem is. how do you take horizontal cells and make them fit into a dynamic menu once it has filted by the manufacture menu selection follow?

runing odbc server no sql

either i need to find a way to auto populate the values that are horizontal in the database. or i need to find a way to filter coulom names within access. im using dreamweaver mx 4

hahaha maybe i need a coffee or somthing but i think i need some help one this one any help would be greatly appreicated im up all day on MSN muckluks@hotmail.com thanks

I would first consider chaging your table design. You should have a table of Makes, a table of models and a table that links the makes to models.

do you mean the link as a releation ship in MS access between the two tables?

Yes, I mean relationships.

well if i were to make relationships with the dataase still all of the values are going to be horizontal, i need them to come up verticle in the dynamic menu on dreamweaver..

give me an example how to make the table just a small example

Makes
MakeID(PK) Make (MakeID Identity Column)
1 Chevy
2 Ford
3 Dodge

Models
ModelID(PK) Model (ModelID Identity Column)
1 Mustang
2 Topaz
3 Ram
4 Truck
5 Monte Carlo
MakesModels
MakeID(FK) ModelID(FK) (MakeID,ModelID Primary Key Clustered)
2 1
2 2
3 3
4 4
1 5


Select ma.Make, mo.Model
From Makes ma
Inner Join MakesModels mm ON ma.MakeID = mm.MakeID
Inner Join Models mo on mm.ModelID = mo.ModelID

Jim