Best Way to Fill ComboBox via ODBC?

[DbHd]

I modeled a database in Access and now am migrating it to MySQL via ODBC. Once everything works without linking tables, I can turn it over to a Ruby On-Rails developer to do the front end.

My issue is how to source the many cbo's on my forms. The first question is how does Access handle cbo source data? Once a cbo is filled, does it hold that for the entire session? Or, does it refresh the source with each click?

My boxes are static for that session so I could write a delimited string in as the source, but is that the best way?

With the notion of momentary ODBC connections grabbing data and closing, would it be best to run a MySQL procedure as the source?

 

[Remou]

Won't the developer be using linq or such like to create a data access layer?

 

[DbHd]

Don't know what Ruby offers, but your point is still valid. I only need to show them the sql for the existing cbos and let them do the conversion to the web front end.

As the saying goes... I'm over-thinking it again!

Thanks