General information
Category:
Forms & Form designer
>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,
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only