When linking to a View using ODBC, you are prompted for the field to use as the primary key.
This is awkward for the users of a database so I wanted to preclude the prompt by using
indexed views. The following all worked for SQL Server 2000, unfortunately MSDE does not support
indexed views, a fact as usual somewhat buried in the documentation. One of our 3 replication sites was
a desktop workstation with MSDE, not a server.
Code provided in screenshot for study only, hence no copy/paste.