Hi,

When i define a referential integrity between 2 tables, does the access database automatically create an index for the relationship ?.

Thanks
Joy

Have you tried it?
What was the result?

Hi,
I created a relationship but i don't see an index. was wondering if the index is created internally and not displayed. i basically need an index on a column which is also a column for the relationship with another table, hence i don't want to create an index on the column if the database internally creates an index for a referential integrity constraint.

Thanks
Joy

In tabledesign mode you can view all the indexes made by you and access by pressing the icon with the lightning bolt, next to the Primary Key Icon, which is a key.

HTH:D