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?