>>>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? :)
Um...I didn't explain it too well, perhaps? You can add a view to a view the same way you add a table to a view. Bring up the add table dialog and click on the radio button that says "views". You should now see all the views in your DBC.