index is blue color marker field that is the primary key for all of my Access tables

[bkel]

I am trying to understand the Links Tab in the database expert- where it shows the Index colors. I have read that mostly primary keys are Red - the 1st indexed. ALLL of my tables from Access Primary Keys - are showing ANY color Other than RED. but Red is assigned to NON primary keys. Please explain???? - what does multi colored ones mean???

thanks,
bkel

 

[BettyJ]

While in the Links tab in Database Expert, click on Index Legend button. It may help.

 

[bkel]

That is what I did and it shows that typically the 1st indexed is RED - and it states Many places that it is Typically assigned to the Primary Key from the database you are pulling it in from. I looked into the Access Tables and NONE of the Primary Keys Are red????- but Other Non Primary keys are???? NONe of the Primary keys are red but some are Blue and other colors -

thanks for helping any more ideas??
bkel