>I have a view defined for a account master table from SQL server.
>It contains two fields code & name. Every form in the application requires the view and to set relation to code to display the name.
>
>
>The index generated on views (even idx ) are erased when the view is closed.
>
>The forms have private data session.
>
>How to set relation to code field ?
>
>Rajesh.
Unfortunately, you have to rebuild the .idx each time the view is run but the set relation is the same as to any other table.
SET RELATION TO expression INTO name_of_view