Thanks for the response. The view designer allows me to do it very easily, but what about when running a program which needs to define its view parameters based on user selects. Specifically, to direct the query to certain tables and links between them may also vary, again based on user request.
Otherwise, I would have to define 3 times 14 times 365 times 10 = 153K remote views with view designer and that without restricting access for specific fields.