Unique Index

K

knowledge76

Registered User.
Local time
Today, 22:20
Joined
Jan 20, 2005
Messages
165
I have a beginner Question....How can I set an unique Index on a field in a table if all the four fields are using duplicate values?
 
You can't.

Add a new field called ID (or something) of type Autonumber and set it as the primary key.

Dave
 
Fair point. I hadn't really realised that was what the OP wanted...

Dave
 
You must log in or register to reply here.

Similar threads

Q
Solved conditional formatting duplicates
2
Replies
21
Views
513
CJ_London
C
O
Query optimization: Why does Access use temporary index instead of index or rushmore for a JOIN query with SUM?
Replies
13
Views
1,057
Josef P.
J
R
Unique values
Replies
12
Views
1,355
RogerCooper
R
S
Solved Add Index Field?
Replies
12
Views
1,699
isladogs
isladogs
S
Export Report to PDF with Index to Records
Replies
7
Views
372
Trevor G
Trevor G

Users who are viewing this thread

Total: 1 (members: 0, guests: 1)
Back
Top Bottom