How can I change the recordsource of a grid to another table with a the same structure.
Assume tableA is the current recordsource
If I go...

grid.recordsource= tableB
grid.refresh

Some of the columns show data from the new table and most contain current record data from tableA for every record of tableB.
This is despite the fact that the controlsource for each column does not contain the table alias.