Remove primary key on table can't update recordset

[osx99]

I have a table (named ELR) which is has a primary key on the first field called ELR and is linked to ELR in another table named 'data input' both in relationships and a query.

The ELR field has a many - 1 relationship on the 'data input' table to the ELR table.

However, I need to update the ELR table data and ELR no longer has unique values so I have removed the primary key and linked them as above but without referential integrity as there is now no primary key.

When i use the database i can change values in the current record but am unable to create a new record or move to a new one. I get error - can't move to dpecified record or cannot update recordset.

Can anyone help?

Thanks,
Osx

 

[Transcend]

Ok, lets start at the beginning.

Why did you remove the primary key from the ELR table? Having duplicate data will cause you all kinds of grief!!!
You will have to extract all the data and delete your duplicates to fix this.

Transcend

 

[osx99]

Originally the table had a unique ELR

I had to remove the primary key as the ELR field only now has duplicate data, the other data in the row is different so there is not actually any duplicate data, only duplicate data in the ELR field.

As ELR now has duplicates I cannot use primary key on this field

So from now on I will always have duplicates in ELR