>I assume all your tables have the fields mentioned in the grid (one wrong move and the grid will reset to default - all fields). Just issue the same alias (TheAlias in my example), and then, when you open the table,
>
> use (lcTheTableName) alias TheAlias
>
>Just take care not to do this while the grid lives, because it will lose recordsource while you reopen the table, and reset again. I've done a grid like that, and ended up having a cursor with the structure identical to the structure of the tables used (and they're sure to have identical structures - they're .scxes :), and then actually filled the cursor with records from the table (and a link field where recno() of the original table is stored). When I reopen the table (i.e. switch to another .scx) I blank all the records in the cursor, and refill from the table. I do filter blank records, but for such small tables that's no overhead.
>
>Actually, this is simply crying out for a view, if it can be done. Really, is it possible to create a view on a table with variable name?

What happened was that I didn't put a recordsource in first. Then when I put one in, it wiped out all my column control sources. I put them back and it works.

I don't know if I could use a view. Not in the view designer, I'm sure, but maybe programatically. Come to think of it, I can't use a view... This is in the old application where there's no database.

Thanks,