July 22nd, 2010 
Gary Access Key
How can I make the primary key in access indexed to allow duplicates?
This is a one to one relationship but I need the primary key to be indexed to allow duplicates but Access automatically changes this to no duplicates. How do I fix this without removing the primary key
You can not have a duplicate primary key. The definition of a primary key is that it is unique (To allow it to relate to a key in another table)
If you still want it to be indexed, you will have to remove the primary key and set it to indexed – duplicates OK.
You do not have to have a primary key.
|
|
Kaba E-Plex 2000 Electronic Access Control-Lock–W/ Key Override $299.99 |
|
|
Master Lock Company Portable Select Access Key Storage Lock $32.28 |
|
|
Master Lock Company Wall Mounted Select Access Key Storage Lock $32.34 |
|
|
Master Lock 5401D Select Access Wall-Mounted Key Storage Box NEW $25.00 |
|
|
KABA E-Plex Kaba eplex Electronic Lock Digital Access Lock Locksmith Icore Keys $249.99 |
|
|
Electronic Key Storage Lock Box Combination Lockbox with Downloadable Access Log $75.00 |
|
|
Access Control Key pads 212W $199.00 |
|
|
Master Lock 5400D Select Access Key Storage Box Set-Your-Own Combination Lock $29.99 |
|
|
Access Control Key pads $120.00 |
|
|
Keri Systems Proximity Key Fob Access Control Card Access System KeyFob $3.99 |
|
|
Electronic Key Storage Lock Box – Wall Mount Combination Lockbox with Access Log $75.00 |
|
|
FLUSH LOCK ACCESS DOOR BOX PANEL LATCH KEY LIFT HANDLE $34.95 |
|
|
MASTER LOCK Safty Select Access Key Storage Box CONTROL $23.02 |
|
|
MASTER LOCK Safty Select Access Key Storage Box CONTROL $30.99 |
|
|
Master Lock 5401D Select Access Wall-Mounted Key Storage Box $29.99 |
|
|
MASTER LOCK Safty Select Access Key Storage Box CONTROL $24.17 |
|
|
MASTER LOCK Safty Security Access Key Storage Box CONTROL $23.99 |
|
|
Master Lock Select Access 5401D Holds 5 Keys $19.99 |
|
|
New Masterlock Wall Mounted Access Key Storage Lock $35.99 |
|
|
Access Control Key pads $345.00 |
|
|
Master Lock 5401D Select Access Wall-Mounted Key Storage Box Own Combination $25.95 |
|
|
new GE Access Point Digital Key Safe indoor outdoor model 001364 $39.00 |
Posted in 
Tags: 
