Creation of duplicate data, remove the index

G

Gregc.

G'day

I am designing a table, that lists the Cost Centres and I wish the make
the Cost Centre Number the Primary Key. The Cost Centres contain both
Numbers and Char ie A74. When I try to do this I get the following
message "The changes you requested to the table were not successfult
because they would create duplicate values in the index, primary key or
relationship. Change the data in the field(s) that contain duplicate
data, remove the index, or redefine the index to permit duplicate
entries and try again".

Is the message appearing because I have the Data Type "Text"?

Regards
Greg
 
G

Gregc.

Please ignore this. I've fixed the problem...I'm a newbie, and have'nt
used Access before.

Greg
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Duplicate values 4
duplicate value error message - new issue 1
How do I find the indices on a table in Access 2003? 4
Duplicate Records Problem 2
"Duplicate values in the index, primary key, or relationship" 2
Duplicate Values in the index, primary key or relationship 3
Data entry creating duplicate rows in table 3
Error Message 1

Top