>is it posible to do a query whith a subquery from the remote view designer?
>
For complex views you can use third party tools, like eView File #9474 or http://www.whitelightcomputing.com/prodvieweditorpro.htm