Create Index using Constraint clause

[Bill Hicks]

Using Access 97:

ALTER TABLE log ADD CONSTRAINT User_ID FOREIGN KEY (User_ID) REFERENCES
Users (User_ID)

This statement should create a index on the field: User_ID and a
relationship between Log and Users
It creates the relationship, but not the Index in the Log table. What is
wrong?

Bill

[John Viescas]

Bill-

If you examine the Indexes collection for the table, you'll find a "hidden"
index built by Access to support the constraint. This works the same way
when you define a relationship via the UI. In their infinite wisdom, the
Access developers decided to hide these "system" indexes so as to not
confuse the "typical" Access user.

--
John Viescas
author, "Running Microsoft Access 97"
http://www.amazon.com/exec/obidos/ISBN=1572313234/
Bill Hicks wrote in message ...