[AccessD] Indexes on a table from relationships

2 questions:

1. This is how I understand indexes in Jet mdbs.  You can have up to 32
indexes on a table.  If you have a relationship with Referential integrity,
Access creates an index on the linked field.  If you set an index on the
same field, you have double indexed it.  In this case, you would want to
remove the index from the indexes popup, and just let the autocreated index
be the index for that field.

Is this correct, or what is wrong with this?

2. Let's say we have two tables, Parent and Child.  Parent links OTM on
Parent.ParentID (PK) join Child.ParentID.  Will this count as one of the 32
allowed indexes for Parent, Child, or both?

Thanks,



Mark Whittinghill
Symphony Information Services
612-333-1311
mwhittinghill at symphonyinfo.com