G Guest Mar 3, 2004 #1 I have a field that won't accept duplicates and it's not a primary key. How can I change it to accept the same data.
I have a field that won't accept duplicates and it's not a primary key. How can I change it to accept the same data.
C Cheryl Fischer Mar 3, 2004 #2 Joy, The Indexed property of the field may be set to "Yes (no duplicates)". You can check and change this in your table's design view. hth, -- Cheryl Fischer, MVP Microsoft Access Law/Sys Associates, Houston, TX Joy said: I have a field that won't accept duplicates and it's not a primary key. Click to expand... How can I change it to accept the same data.
Joy, The Indexed property of the field may be set to "Yes (no duplicates)". You can check and change this in your table's design view. hth, -- Cheryl Fischer, MVP Microsoft Access Law/Sys Associates, Houston, TX Joy said: I have a field that won't accept duplicates and it's not a primary key. Click to expand... How can I change it to accept the same data.
