Two suggestions - neither as simple as you want:

1) Rewrite the code so the view is only opened once and is requeried elsewhere. All of my remote views share a connection, so I open them empty when I load the form and requery as necessary.

2) Use a form method or class method to open the view which also indexes it.

HTH
Barbara


>Has anyone used indexs on remote views, on SQL server tables,in fox. Is there a way to set up the index so that when the table is closed in fox the index does not go away.
>
> The problem is I have a remote view in an application. The application opens and closes the file at different points. So if I set up an index on the first pass of this table when the table is closed and opened again the index has to be recreated. I need a permanent Index!!!