Tony,
Check DBSetProp() which allows you to set field properties in a view. The easiest way to learn how to handle this is to run GenDBC.PRG and look at the resulting file (Be careful - if you accidentally RUN the PRG it will happily overwrite all of your DBC without asking you).
HTH
Barbara
>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.