Drop Down Menu selection query for recordset.

i looking utilize dynamic drop down menu query recordset...i using colfusion import ms access database contains following fields: "model date", "name", "points" , "target".  each time database updates, "model date" field contains date , time model run.  have figured out how create dynamic drop down using select distinct "model date" , have figured out how create dynamic recordset displayed showing "name", "points" , "target" data. 

 

i want user select "model date" drop down, hit submit button , have appropriate "name", "points" , "target" data queried , shown below.

 

the query should take selection "model date" dropdown , query "name", "points" , "target" fields particular "model date"

 

i admit knowledge of sql , coldfusion not best, seems simple task , missing 1 or 2 pieces of cog put together.

 

 

the database looks this:

 

model date...........name..........points........target

8/1/2010 08:00......john doe.....1,250.........5.55%

8/1/2010 08:00......jane doe.....850............2.35%

8/1/2010 08:00......bill smith....11,832........-123.23%

8/2/2010 09:02......john doe.....1,323.........6.67%

8/2/2010 09:02......jane doe.....1,001.........3.21%

8/2/2010 09:02......bill smith....10,235........-110.26%

 

the dropdown show "model dates"

8/1/2010 08:00

8/2/2010 09:02

 

for example, if 8/1/2010 08:00 selected dropdown, want following displayed:

 

name..................points...................target

john doe.............1,250....................5.55%

jane doe.............850.......................2.35%

bill smith............11,832...................-123.23%

 

any or suggestions appreciated!!!

 

thanks,

 

mike

there several ways go this. search web 'dependent drop down' or 'cascading drop down' ideas.

More discussions in Develop server-side applications in Dreamweaver

adobe