>I have a grid control that I would like to display the contents of a single table. This table gets over-written through an odbc call to mysql. The table structure may not be the same twice in a row. How do I get the grid to dynamically refresh without knowing what the table structure will look like?
>
>Any ideas would be greatly appreciated...
>
>Thanks in advance-
>
>Tom Welch


Hi Tom,

Yiu can get the necessary info about the table structure with FCOUNT() and FIELD() functions. Then you can readjust the number of columns in the grid, and reassign RecordSource and column ControlSourses as necessary.