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?