I thought so but Stonefield seem so to overkill for my one time need. Looks like I would have to invest some time in mastering the tool then depoy.

Thanks for the reply. Do you have any experience in use the tool?


Ken,
>
>I don't think the view designer is allowed in runtime.
>
>You might want to look at a tool like SFQuery from Stonefield. http://www.stonefieldquery.com/
>
>>Is it possible to call view designer in a form? Using VFP7, I would want to create a un-normalized table pulling together a number of tables then offer the ability to select/sort data as needed.
>>
>>Later in the form would want to offer the ability to display the results in the excel file.
>>
>>Can this be done...if so any samples that I can look at?