>I have tried that. I get the following error - Error loading file - record number 8. Grid1(or one of its members).ControlSource : Alias 'partstank' is not found.
>
>I know partstank is there because if I put a browse in after the sql statement creating it, it shows with the records.
>
>Does partstank have to be added to the data environment before it is available for use?

Where do you do this select statement? It must be in the Load or early.