>>How do you create a VIEW from within a VIEW?
>
>Go to the view designer and select add table. Notice the radio button on the bottom right that says "Tables/Views"? Click on views. You'll be able to see the views you have already defined. This is particularly useful if you need to combine remote data with local data, because VFP won't allow you to add a remote table to a local view or a local table to a remote view. Is this what you needed?
---
hi Micheal
what I want to do is to set a VIEW within a VIEW..
can you show me some code to do that? :)