duplicate values (was Hi, my name is Dimitar)

[tsvetkovd]

I am a student in applied computing course, we've just began learning access. I had a simple task that I think I've done it, except one error that keeps popping up every time I try to set up a PK for a particular table. Please tell me, what is wrong. I've tried to fix that, following the suggestions in the dialog box, but the error kept popping up. Please open file Capture3.JPG to see the error. Thank you!

 

[David R]

Re: Hi, my name is Dimitar.

The error is telling you what is wrong - whatever you're trying to set as a PK is in the table twice somewhere. Use the Query Wizard to do a Find Duplicates query and correct that, then you should be able to set it as the PK.

 

[pbaldy]

Re: Hi, my name is Dimitar.

Moved thread from introductions forum.

 

[tsvetkovd]

Thank you for your quick reply. I will do it right away