Duplicate Entries Error

[Tezdread]

Hi all,

Could someone advise where I need to go to locate the problem for this error?

"The changes you requested to the table were not successful because they would create duplicate values in the index, primary key, or relationship. Change the data in the field or fields that contain duplicate data, remove the index or redefine the index to permi duplicate entries."

I've deleted all the relationships, none of my tables have a primary key now and I have one main table and a few lookup tables...

Thanks

Tezdread
"With every solution comes a new problem"

 

[Tezdread]

scrap that I found it...Tables - Design View - Table Field -Indexed - Yes (No Duplicates) so I set this to No and it's all sorted.

Tezdread
"With every solution comes a new problem"