I agree about not wanting to use views, but I'm looking for a good alternative and I think the session class is the only other option. The problem with session class is that it is not supported in FPD26 of course and this code is also in our older FPD26 app so I will have to do 2 solutions instead of one. I'll research the session class and see what I can work out for the VFP7 code.

Thanks for your ideas Mark,
Tracy

>Sorry, I missed that point. Go back to MyAlias = ALIAS(). But what if more than one table is open before you restore a view? Can you not just use a Session class to do this in? I do not save environments in views, so I do not know if they would respect the private DS of session class. I also just do not like them in a runtime/production setting.
>
>>Your changes are interesting. I had it using SELECT instead of alias() originally but when it restored the view, the work area was different for the file that was originally selected and it bombed. Is a view supposed to maintain the same work areas for the files?
>>
>>Tracy