Drop down with filtered ODBC data source

[KRM240_]

Does anyone have sample code that can show me how to link a drop down to a remote database table

ie: I have a list of projects by year and I would like to have the drop down show me all projects for 1 specific year where more than 1 year is present.

I am not sure which way to do this, read all the data in to an array, then filter based on the year;

or

Have the form allow you to select the year, then make the call to get the data for that 1 year

Looking for a good example so I can learn the process.

Thanks in advance

[KRM240_]

Problem solved, was able to get 3 drop downs to work that filter the ODBC data that I needed.

Solution was actually in the Custom object library "Data DropDownList"

Had to make some code changes, but works!

Oh yes, the other issue is I believe that there is a bug with the ODBC drivers for Windows 7 64 bit.  I could only get the 32 bit drivers to work.