Hi Kevin,
I think your problem is that you're building an IDX index instead of a tag in a CDX. You don't want to know the hours I've wasted tracking down problems due to a temporary IDX, even when it wasn't in the same data session.
Just change your index statement to INDEX ON Id TAG Id. The CDX will be deleted when you close the view.
>I have a view, v_Clients, which is based on an ODBC data connection
>to an MS Access table.
>
>This view is the primary table in a form called Clients. The user
>can pick from a list if clients, and the Client Id is passed into
>the form.
>
>In the Init of the form, I then want to
SEEK() the Id in the view so I can display the data.
>
>The problem is that this is a multi instance form. In the first instance
>I could
INDEX ON Id TO Id, but then in
>each of the remaining instances, the index file is not accessable.
>
>What I really need is a compound index file for the view.
>
>How do I do this?