>>I have another question. I tried opening the view from the command window (Use mydatbase!myview ) and see that it opens as well all the of the tables included in the view. I guess that makes sense. My new question is: I had been opening these tables with their tags set in another part of the program." Does using a view which uses these same tables mean I can refer to them as is, or should I still open them again with (alias and correct tag) and refer to them in that way? I hope this question makes sense - as I had mentioned, I wasn't using the data environment so to see all of these tables open 'automatically' with one use command sort of surprised me.
>
>Sylvia,
>
>The view will reopen the table no matter what you do because it doesn't want to alter your current data environment by moving record pointers or setting index orders on you. The view will always leave those other work areas open and you need to close them either by having a form close its data environment or in code. I usually use private data sessions for each form and let the DE auto close tables.

Jim -

Thanks for the info. I'll have to add this to my code then.

Sylvia