>>how to add a temporary table to dataenv which changes every time it loads with same alias name & is source to a grid control.
>
>If you mean create a cursor that you can bond a grid to, you can run your SQL from te Form.Load.

Will this work in VFP 6? I had problems if I explicitly referenced a non-existent alias (that I was planning to create in the form.load) and received numerous errors. I eventually moved the sql statement to the dataenvironment.beforeopentables and was successful. Have you encountered this problem?