i execute a procedure which does a CREATE VIEW TO filename and then a SET VIEW TO filename. after the SET VIEW my grid is blank. i believe it does a create view because later it will close all the databases (have not executed that far into the logic yet).

have read int ut to try the following, which i did:

grid1.recordsurcetype = 0
grid1.recordsource = ""
set view to filename
grid1.recordsourcetype = 1
grid1.recordsource = "table1"

the recordsource = "", immediately loses my column controlsource. and then the set view still blanks my table.

any suggestions would be appreciated. also, why does everyone on ut suggest recordsource = "" ? it does not allow your grid to keep its column controlsource, text formats, etc.

thanks - brenda