Referential integrity ?

[joyaccess1]

Hi,

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

Thanks
Joy

 

[Guus2005]

Have you tried it?
What was the result?

 

[joyaccess1]

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

 

[Guus2005]

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