Maybe I don't understand this as well as I thought I did.
I have a table that has two primary keys. The primary key was defined by selecting the Key icon on the tool bar. One primary key is an autonumber field the other is not. Both are indexed and set to no duplicates... Now... I go to the tool bar and click on the Index icon and look at the indexes listed in that dialog box and both of my primary keys say Primary No and Unique Yes. What's up? Shouldn't they be the same in both places. The reason this is bothering me is that I was using the database documentor and I was trying to get a report that would show me all the primary keys in the database and they didn't indicate a primary key on some field that are set as primary. Whasssssup?
I have a table that has two primary keys. The primary key was defined by selecting the Key icon on the tool bar. One primary key is an autonumber field the other is not. Both are indexed and set to no duplicates... Now... I go to the tool bar and click on the Index icon and look at the indexes listed in that dialog box and both of my primary keys say Primary No and Unique Yes. What's up? Shouldn't they be the same in both places. The reason this is bothering me is that I was using the database documentor and I was trying to get a report that would show me all the primary keys in the database and they didn't indicate a primary key on some field that are set as primary. Whasssssup?
